Re: [GENERAL] Foreign key locks

2004-09-02 Thread Vivek Khera
> "SS" == Stephan Szabo <[EMAIL PROTECTED]> 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 initall

[GENERAL] Foreign key locks

2004-09-02 Thread Ulrich Wisser
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 ---(e