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

• How is this possible? (more on deadlocks) at 2004-08-24 20:41:23 from Carlos Moreno

pgsql-general by date

Next:	From: Tom Lane	Date: 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 Vugt	Date: 2004-08-24 21:16:37
	Subject: NAB : insert into <table> select distinct <fields> => when used on null, distinct causes loss of type knowledge