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.