Hi,

> >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
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com