X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6494552814 for ; Mon, 13 Jun 2005 13:05:28 -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 58002-07 for ; Mon, 13 Jun 2005 16:05:24 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id BCC3F52812 for ; Mon, 13 Jun 2005 13:05:23 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id A0F2D40E059; Mon, 13 Jun 2005 17:05:10 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 31E6815ED8; Mon, 13 Jun 2005 17:03:36 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01347-09; Mon, 13 Jun 2005 17:03:34 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 0B73415ED5; Mon, 13 Jun 2005 17:03:34 +0100 (BST) Message-ID: <42ADAE55.2070704@archonet.com> Date: Mon, 13 Jun 2005 17:03:33 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Csaba Nagy Cc: "ON.KG" , Postgres general mailing list Subject: Re: duplicate key violates unique constraint References: <42A95936.3060002@archonet.com> <20050610095655.0215752956@svr1.postgresql.org> <10813889593.20050613202239@on.kg> <42AD9B9D.6080902@archonet.com> <1118676122.2720.24.camel@coppola.muc.ecircle.de> <42ADAAFB.30404@archonet.com> <1118678332.2720.27.camel@coppola.muc.ecircle.de> In-Reply-To: <1118678332.2720.27.camel@coppola.muc.ecircle.de> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/629 X-Sequence-Number: 79337 Csaba Nagy wrote: > That would work indeed. Bit I guess the savepoint solution will be the > simplest and fastest if the OP has or can install 8.0 version. I'd say so. Otherwise you'll just sit on the lock, and then still have to deal with an error later anyway when the lock times out. -- Richard Huxton Archonet Ltd