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