Re: 8 and 8i default constraint behavior

"Galen Boyer" <galenboyer_at_yahoo.com> wrote in message news:uwv7s10mk.fsf_at_primix.com...
> On Tue, 8 May 2001, howardjr_at_www.com wrote:
>
> > deferrable makes far more sense.
>
> Do you say this because application code shouldn't need to know
> which order it needs to insert rows, only that it needs to insert
> to all tables?

Possibly. My real problem is with unique indexes used to enforce primary and unique key constraints taking it upon themselves to be dropped whenever I disable a constraint. As a DBA I'd prefer to be in charge of what gets dropped and when, thanks very much. The point being that primary and unique keys that are created deferrable get NON-unique indexes to enforce them, and those indexes are *not* dropped automatically when the constraint is disabled.

Regards
HJR
> --
> Galen
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.
Received on Tue May 08 2001 - 16:12:33 CDT