Foreign key locks

On Thu, 2 Sep 2004, Ulrich Wisser wrote:

yes, I have been hit by the, now also known to me, foreign key locking
"feature". And yes I did read that I should use "defer" to solve the
problem. Question is:

Do I have to recreate my schema with all foreign keys set to "initially
defered deferable"?

You really should just need to drop the constraints and recreate them, not
the entire schema.

"SS" == Stephan Szabo <sszabo@megazone.bigpanda.com> writes:

SS> You really should just need to drop the constraints and recreate them, not
SS> the entire schema.

So do I want to do deferred checks on all transactions, or just
some/one of them? I'm assuming that if the advice is to make them
initally deferred that means all of them, but I wanted to be sure.

Thanks!

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/