|Subject||RE: [IB-Architect] Rebuilding foreign keys system indexes|
>Yes. That's what I meant. First, it means that reflexive constraints
> > 3) Extend the foreign key constraint definition language with
> > the option [[IN]ACTIVE]....
>... tell the engine to allow any user to
>break the RI by not checking the FK declarations at all when inserting,
>deleting and updating?
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.