Skip site navigation (1) Skip section navigation (2)

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

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Carlos Moreno <moreno(at)mochima(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How is this possible? (more on deadlocks)
Date: 2004-08-24 21:26:57
Message-ID: 20040824142502.O59661@megazone.bigpanda.com (view raw or flat)
Thread:
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.

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-24 21:30:56
Subject: Re: NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge
Previous:From: Frank van VugtDate: 2004-08-24 21:16:37
Subject: NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group