Foreign key locks

From: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Foreign key locks
Date: 2004-09-02 09:06:05
Message-ID: 4136E27D.3040705@relevanttraffic.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2004-09-02 10:38:09 Re: vacuum full for all databases
Previous Message Ulrich Wisser 2004-09-02 08:51:36 Re: Hebrew support -- please help !