> -----Original Message-----
> From: Ann Harrison [mailto:harrison@...]
> Sent: Viernes 3 de Noviembre de 2000 13:24
>
> >... tell the engine to allow any user to
> >break the RI by not checking the FK declarations at all when inserting,
> >deleting and updating?
>
> Yes. That's what I meant. First, it means that reflexive constraints
> can at least be documented. Second, it reduces the complexity of loading
> data, especially if there's an ALTER CONSTRAINT [[IN]ACTIVE] and if the
> system validates the data before activating an constraint.

Hmmm, you are trying to implement poor man's version of DEFERRED
constraints, but manually controlled: deactivate a constraint, do all the
operations and then activate the constraint. Will the constraint check the
data when it's activated again?

C.