Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EFA472E021A for ; Thu, 20 Mar 2008 12:18:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 44959-03-2 for ; Thu, 20 Mar 2008 12:18:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 1E0B82E0245 for ; Thu, 20 Mar 2008 12:18:03 -0300 (ADT) Received: (qmail 18827 invoked by uid 0); 20 Mar 2008 15:17:58 -0000 Received: from 62.218.164.126 by www066.gmx.net with HTTP; Thu, 20 Mar 2008 16:17:58 +0100 (CET) Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset="us-ascii" Date: Thu, 20 Mar 2008 16:17:58 +0100 From: "Jan Peters" In-Reply-To: <9890.1206025894@sss.pgh.pa.us> Message-ID: <20080320151758.188000@gmx.net> MIME-Version: 1.0 References: <20080320134208.42400@gmx.net> <9890.1206025894@sss.pgh.pa.us> Subject: Re: Rollback locks table - why? To: Tom Lane X-Authenticated: #16900582 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/SlgMevarSYjRaeoheGTRHxjPV1Aqvv6m0WLbJ/H MEOzEVo+S+v4nRfDQvenqau0ga7KYAhEHUOQ== Content-Transfer-Encoding: 7bit X-GMX-UID: ccSoADgua2AoIILXNnUyVeU6OWhhaocZ X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/155 X-Sequence-Number: 30483 Hello Tom, > so the problem must be in something you didn't show us. What exactly > are you doing to decide that you need to roll back? Also, none of these > statements (except the CREATE) would take an exclusive lock on test, so > there must be something else going on that you didn't show us. That is exactly what confuses me. I just put the above code in the SQL Query Editor of my Admin App (e.g. PGAdmin III) and click the run button, nothing else. First time I get "duplicate unique key" second time " ERROR: current transaction is aborted, commands ignored until end of transaction block"... Regards Jan -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf@gmx