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

From David E. Wheeler
Subject Re: FOR KEY LOCK foreign keys
Date
Msg-id 98402EDE-8D91-41BE-8387-2C687F14265B@kineticode.com
Whole thread Raw
In response to FOR KEY LOCK foreign keys  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: FOR KEY LOCK foreign keys  (Robert Haas <robertmhaas@gmail.com>)
Re: FOR KEY LOCK foreign keys  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
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? 

Best,

David



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Allowing multiple concurrent base backups
Next
From: "Kevin Grittner"
Date:
Subject: Re: limiting hint bit I/O