Horton

Re: Foreign key locks

Stephan Szabo <sszabo@megazone.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2004-09-02T14:51:28Z
Lists: pgsql-general 
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.