Re: BUG #1998: transaction locks parent record when it shouldn't

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Dmitry Panov <dmitry(at)tula(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1998: transaction locks parent record when it shouldn't
Date: 2005-10-25 14:27:51
Message-ID: 20051025142751.GI1957@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jean-Pierre Pelletier 2005-10-25 16:02:34 RIGHT JOIN is only supported with merge-joinable join conditions, PostgreSQL 8.1 beta3
Previous Message Bruce Momjian 2005-10-25 13:23:03 Re: BUG #1993: Adding/subtracting negative time intervals