Foreign key locks

Ulrich Wisser <ulrich.wisser@relevanttraffic.se>

From: Ulrich Wisser <ulrich.wisser@relevanttraffic.se>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2004-09-02T09:06:05Z
Lists: pgsql-general
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