Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT deadlocks (bug or feature?) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: INSERT deadlocks (bug or feature?)
Date
Msg-id 14459.1117203332@sss.pgh.pa.us
Whole thread Raw
In response to INSERT deadlocks (bug or feature?)  (evgeny gridasov <eugrid@fpm.kubsu.ru>)
List pgsql-bugs
Tree view 
evgeny gridasov <eugrid@fpm.kubsu.ru> writes:
> ... and we recieve a deadlock!
> Easy to understand why: each insert statement generates query like:
> SELECT 1 FROM ONLY "public"."ref" x WHERE "id" = $1 FOR UPDATE OF x
> So, is this behaviour of postgresql is a bug or feature?

An extremely well-known bug ... which is fixed in CVS tip.

            regards, tom lane

pgsql-bugs by date:

Previous
From: shd@t2.technion.ac.il
Date:
Subject: adding users to sshd
Next
From: Tom Lane
Date:
Subject: Re: BUG #1682: subselect generates multiple rows