Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7582A2E0136 for ; Thu, 20 Mar 2008 12:42:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 93619-05 for ; Thu, 20 Mar 2008 12:41:46 -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 88C752E005A for ; Thu, 20 Mar 2008 12:38:29 -0300 (ADT) Received: (qmail 25826 invoked by uid 0); 20 Mar 2008 15:37:23 -0000 Received: from 62.218.164.126 by www065.gmx.net with HTTP; Thu, 20 Mar 2008 16:37:22 +0100 (CET) Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset="us-ascii" Date: Thu, 20 Mar 2008 16:37:23 +0100 From: "Jan Peters" In-Reply-To: <10458.1206026782@sss.pgh.pa.us> Message-ID: <20080320153723.113670@gmx.net> MIME-Version: 1.0 References: <20080320134208.42400@gmx.net> <9890.1206025894@sss.pgh.pa.us> <20080320152034.190800@gmx.net> <10458.1206026782@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+I7sA4ubGIns9e1GBLJN1eUtQnIixlBMwARlzKIH jWl+NxopZ/+inF4kjEG8hC6b2J6p6K5yrCUA== Content-Transfer-Encoding: 7bit X-GMX-UID: 3emAEyAMbXB+NYOTMzU28O8iLyUmZUjw 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/157 X-Sequence-Number: 30485 Yes, Tom, it looks like this: Locked Transaction:458553 I misread that. Sorry for that, I am actually a Geographer and just "using" the tools at hand. So I was not clear enough, it is a lock, but it's just the one of the transaction, right. That still does not explain why the Query Editor locks up, hm. I just tried to send the transaction to my servlet and it worked on the server es well. Seems the JDBC driver interprets the string differently. Well, if it's working on the server, I will not keep trying in the editor, although it might be nice, to have a solution. But as long as I use the console for testing purposes from now on, it's fine for me. Thanks again, Craig and Tom, if you still have an idea what might cause this behaviour, let me know. Otherwise: Happy Easter! 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