Re: Foreign key deadlocks - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Foreign key deadlocks
Date
Msg-id 20040927013707.GA18234@winnie.fuhr.org
Whole thread Raw
In response to Foreign key deadlocks  ("Shawn Chisholm" <ShawnC@sandvine.com>)
Responses NOTICE: adding missing FROM-clause entry for table
Duplicate entries with different primary keys (SERIAL)
List pgsql-novice
On Sun, Sep 26, 2004 at 08:55:46PM -0400, Shawn Chisholm wrote:

> Hi all, quick question related to some scalability problems I
> have been seeing: do foreign key references acquire write locks on
> the row they are referencing during an insert, and are these locks
> held until the end of the transaction?

This was recently brought up in pgsql-general -- see the original
message and my followup:

http://archives.postgresql.org/pgsql-general/2004-09/msg00405.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: "Shawn Chisholm"
Date:
Subject: Foreign key deadlocks
Next
From: Gaetano Mendola
Date:
Subject: Re: Using PERFORM in plpgsql throws compile errors