Re: FOR KEY LOCK foreign keys

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>, Joel Jacobson <joel@gluefinance.com>
Date: 2011-01-14T18:00:48Z
Lists: 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 deadlock example?

Best,

David