Subject Re: [Firebird-Architect] Re: [IB-Architect] Rebuilding foreign keys system indexes
Author Ann W. Harrison

>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.


We have answers.