Re: How is this possible? (more on deadlocks) - Mailing list pgsql-general

From Stephan Szabo
Subject Re: How is this possible? (more on deadlocks)
Date
Msg-id 20040824142502.O59661@megazone.bigpanda.com
Whole thread Raw
In response to How is this possible? (more on deadlocks)  (Carlos Moreno <moreno@mochima.com>)
List 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.

pgsql-general by date:

Previous
From: "ruben20@superguai.com"
Date:
Subject: Upgrading PostgreSQL 7.1.3
Next
From: Tom Lane
Date:
Subject: Re: NAB : insert into select distinct => when used on null, distinct causes loss of type knowledge