On Thu, 6 Aug 2009, Paul Rogers wrote:
> Why does the attached script fail with a foreign key constraint violation?
Referential actions are not deferred when a constraint is marked
deferrable (as that appears to be what the spec wants), so ON DELETE
RESTRICT will still fail on the statement, while ON DELETE NO ACTION (ie,
only check at constraint check time) should wait to the end.