Re: FOR KEY LOCK foreign keys - Mailing list pgsql-hackers

From Robert Haas
Subject Re: FOR KEY LOCK foreign keys
Date
Msg-id AANLkTi=+=5fqPRaWa_YKrQA3BYKmZubfPoL7Mbb=W9+4@mail.gmail.com
Whole thread Raw
In response to Re: FOR KEY LOCK foreign keys  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: FOR KEY LOCK foreign keys  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Fri, Jan 14, 2011 at 1:00 PM, David E. Wheeler <david@kineticode.com> wrote:
> On Jan 13, 2011, at 1:58 PM, Alvaro Herrera wrote:
>
>> Something else that might be of interest: the patch as presented here
>> does NOT solve the deadlock problem originally presented by Joel
>> Jacobson.  It does solve the second, simpler example I presented in my
>> blog article referenced above, however.  I need to have a closer look at
>> that problem to figure out if we could fix the deadlock too.
>
> Sounds like a big win already. Should this be considered a WIP patch, though, if you still plan to look at Joel's
deadlockexample? 

Alvaro, are you planning to add this to the CF?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: limiting hint bit I/O
Next
From: Simon Riggs
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Exit from base backups when shutdown is requested