Thread

1. Foreign key locks

   Ulrich Wisser <ulrich.wisser@relevanttraffic.se> — 2004-09-02T09:06:05Z

   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
   
   
   

2. Re: Foreign key locks

   Stephan Szabo <sszabo@megazone.bigpanda.com> — 2004-09-02T14:51:28Z

   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.
   
   
   

3. Re: Foreign key locks

   Vivek Khera <khera@kcilink.com> — 2004-09-02T20:59:46Z

   >>>>> "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/