Horton

Re: How is this possible? (more on deadlocks)

Stephan Szabo <sszabo@megazone.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Carlos Moreno <moreno@mochima.com>
Cc: pgsql-general@postgresql.org
Date: 2004-08-24T21:26:57Z
Lists: pgsql-general 
On Tue, 24 Aug 2004, Carlos Moreno wrote:

> Ok, now I'm really intrigued by what looks to me
> (possibly from a naive point of view) like a bug,
> or rather, a limitation on the implementation.

Yep.  See recent (and historical) discussions on
needing a weaker lock than FOR UPDATE for handling
foreign keys.