Re: BUG #1998: transaction locks parent record when it shouldn't - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #1998: transaction locks parent record when it shouldn't
Date
Msg-id 20051025142751.GI1957@surnet.cl
Whole thread Raw
In response to BUG #1998: transaction locks parent record when it shouldn't  ("Dmitry Panov" <dmitry@tula.ru>)
List pgsql-bugs
Dmitry Panov wrote:

> I discovered that inserting a child record locks parent record so that if
> another translation tries to insert another child record which references
> the same parent.

This is fixed in 8.1.

--
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Next
From: "Jean-Pierre Pelletier"
Date:
Subject: RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3