|Subject||RE: [Firebird-general] Re: Snapshot Isolation in A Critique of ANSI SQL Isolation Levels|
|Author||Claudio Valderrama C.|
> -----Original Message-----And isn't there the possibility that a constraint that was validated
> From: Firebirdfirstname.lastname@example.org
> [mailto:Firebirdemail@example.com] On Behalf Of Ann W. Harrison
> Sent: Lunes, 18 de Octubre de 2010 13:47
> > Not sure I understand the question completely, but wouldn't a
> > DBMS that allows deferred constraints need to do exactly that?
> Actually, not exactly. The better way to handle deferred constraints
> is to perform the constraint check immediately, and retain only the
> failures, then recheck the failures on commit. Some - in a properly
> designed system all - of the failures will be corrected. There's
> no reason to recheck all the actions of the transaction.
(accepted) immediately, would fail if run when all actions have been done
and commit is executed?