Foreign key locks - Mailing list pgsql-general

From Ulrich Wisser
Subject Foreign key locks
Date
Msg-id 4136E27D.3040705@relevanttraffic.se
Whole thread Raw
Responses Re: Foreign key locks  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List 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


pgsql-general by date:

Previous
From: Ulrich Wisser
Date:
Subject: Re: Hebrew support -- please help !
Next
From: Oleg Bartunov
Date:
Subject: Re: vacuum full for all databases