On 11/18/2015 01:17, Darren Duncan wrote: > > Deferred constraints are definitely a benefit. > > They allow you to express constraints otherwise not possible, for > example that a record may exist in table X if and only if a > counterpart exists in table Y, such as balancing records in a > double-entry accounting system. Granted all you really need for this > is the ability to change multiple tables as a single atomic operation, > but failing that ability, deferred constraints are the way SQL > provides to do it.
I agree they can be beneficial, but not in all cases. Depends on what you do. It would have been great if it was an option, ex. "CONSTRAINT LEVEL [STATEMENT|TRANSACTION];". Yuri
