Re: Foreign key locks - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Foreign key locks
Date
Msg-id 20040902075103.X9941@megazone.bigpanda.com
Whole thread Raw
In response to Foreign key locks  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List 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.


pgsql-general by date:

Previous
From: Daniel Martini
Date:
Subject: Re: The future of built-in geometric data types
Next
From: Ying Lu
Date:
Subject: "\d tablename" to get column name, and column type by using JDBC