Re: Experience with foreign keys across schemas?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 20 Nov 2004 02:02:41 -0800
Message-ID: <73e20c6c.0411200202.6dc9091f@posting.google.com>

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<re1qp0hbc4vads0k1b4p2qr5c5cqfbq29g_at_4ax.com>...

> Today, I was asked to setup a new schema with tables which will
> contain foreign key references to tables in another schema.

Nothing wrong with that. Works like a charm.

> I don't like that. I am sure that's wrong, but am missing arguments.
> OK, things like "delete from table <tralala> cascade" or "drop user
> <john> cascade" tend to be dangerous. What else?

What's that got to do with multiple schemas and RI, boss? Received on Sat Nov 20 2004 - 04:02:41 CST