pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ricardo Durao <durao@pcsolution.com.br>
To: pgsql-admin@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: DEADLOCK INSERT
Date: Wed, 15 Jun 2005 00:16:10 -0300
Message-ID: <002601c57158$9432b8e0$933311c9@starwarkzed40f> (raw)


Hello,


Tom Lane

 I am using version 7.4.8 and I think that I have this problem(bug) that is 
describe here for you.



_________________________________________________________________________

Re: INSERT deadlocks (bug or feature?)



From: Tom Lane <tgl ( at ) sss ( dot ) pgh ( dot ) pa ( dot ) us>
To: evgeny gridasov <eugrid ( at ) fpm ( dot ) kubsu ( dot ) ru>
Subject: Re: INSERT deadlocks (bug or feature?)
Date: Fri, 27 May 2005 10:15:32 -0400



evgeny gridasov <eugrid ( at ) fpm ( dot ) kubsu ( dot ) 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

_________________________________________________________________________


How I can fix this in my version. Have a Pacth ? I can get the source of the 
file and re-compile the Postgresql ?

Thanks, for any Help.

Ricardo DurĂ£o




" 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.2/14 - Release Date: 14/6/2005




Message-ID: <002601c57158$9432b8e0$933311c9@starwarkzed40f>
Permalink:  ../002601c57158$9432b8e0$933311c9@starwarkzed40f/
Also on:    postgresql.org/message-id/002601c57158$9432b8e0$933311c9@starwarkzed40f

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: durao@pcsolution.com.br, tgl@sss.pgh.pa.us
  Subject: Re: DEADLOCK INSERT
  In-Reply-To: <002601c57158$9432b8e0$933311c9@starwarkzed40f>
  References: <002601c57158$9432b8e0$933311c9@starwarkzed40f>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox