I recently had cause to use a deferred foreign key constraint for the
first time. I like it. It seems it could make life simpler, especially
when an obstinate ORM insists on doing things in the wrong order.
The only downside I can see is it may be harder to track down where a
violation occurred since the error won't be raised until commit.
Are there any other downsides to just setting all my foreign keys to
initially deferred?
Thanks.
--
Jack Christensen
jackc@hylesanderson.edu