On Fri, 2011-04-08 at 14:08 -0500, Jack Christensen wrote:
> Are there any other downsides to just setting all my foreign keys to
> initially deferred?
It may consume memory resources until the transaction is complete.
Also, when it's possible to write the SQL in an order that always
maintains the integrity of the FK, then it's usually more readable and
understandable. So using immediate constraints may encourage a more
readable style.
Regards,
Jeff Davis