Subject | RE: [IB-Architect] Rebuilding foreign keys system indexes |
---|---|
Author | Ann Harrison |
Post date | 2000-11-03T17:24:16Z |
>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.
Regards,
Ann