Subject Re: [Firebird-Architect] Re: [IB-Architect] Rebuilding foreign keys system indexes
Author Martijn Tonies

> >What do DEFERRED constraints actually mean? When DO they start
> >checking? And when don't they?
> Deferred constraints are evaluated at commit, not at verb
> execution. The architecture for them is in place - deferred
> work, etc., but the amount of tracking necessary to implement
> them was beyond the memory capacity of 1990 computers. We
> now regularly keep more information - though not the right
> information necessarily - to do this.

Hmm - thought so (about the commit time, that is). I can think
of situations where this might be useful indeed.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions

See you at the First European Firebird Conference in May in Fulda, Germany