--- In Firebird-Architect@yahoogroups.com, "Claudio Valderrama C."
<cvalde@u...> wrote:

> > -----Original Message-----
> > From: Ann Harrison [mailto:harrison@n...]
> > 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?

Claudio,

What do DEFERRED constraints actually mean? When DO they start
checking? And when don't they?

--
Martijn Tonies
Upscene Productions