Re: FOR KEY LOCK foreign keys
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: David E. Wheeler <david@kineticode.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>, Joel Jacobson <joel@gluefinance.com>
Date: 2011-01-14T18:14:18Z
Lists: pgsql-hackers
Excerpts from David E. Wheeler's message of vie ene 14 15:00:48 -0300 2011: > 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? Not necessarily -- we can implement that as a later refinement/improvement. -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support