Обсуждение: Foreign key locks
Hi, 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"? Ulrich
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/