Re: [GENERAL] Deferred foreign key constraint downsides

2011-04-08 Thread Jeff Davis
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 t

Re: [GENERAL] Deferred foreign key constraint downsides

2011-04-08 Thread Jerry Sievers
Jack Christensen writes: > 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 trac