X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4CAB2528AE for ; Wed, 15 Jun 2005 00:16:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62115-06 for ; Wed, 15 Jun 2005 03:16:22 +0000 (GMT) Received: from vila.pcsolution.com.br (vila.pcsolution.com.br [200.189.32.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2D35D5288E for ; Wed, 15 Jun 2005 00:16:19 -0300 (ADT) Received: from starwarkzed40f ([192.168.251.1]) by vila.pcsolution.com.br (8.11.6/8.11.6) with ESMTP id j5F3FsQ18553; Wed, 15 Jun 2005 00:15:55 -0300 Received: from 127.0.0.1 (AVG SMTP 7.0.323 [267.7.2]); Wed, 15 Jun 2005 00:16:10 -0300 Message-ID: <002601c57158$9432b8e0$933311c9@starwarkzed40f> From: "Ricardo Durao" To: Cc: "Tom Lane" Subject: DEADLOCK INSERT Date: Wed, 15 Jun 2005 00:16:10 -0300 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Mime-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.365 tagged_above=0 required=5 tests=SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200506/96 X-Sequence-Number: 17851 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 To: evgeny gridasov Subject: Re: INSERT deadlocks (bug or feature?) Date: Fri, 27 May 2005 10:15:32 -0400 evgeny gridasov 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