From: Jan Peters <petersjan@gmx.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rollback locks table - why?
Date: Thu, 20 Mar 2008 16:37:23 +0100
Message-ID: <20080320153723.113670@gmx.net> (raw)
In-Reply-To: <10458.1206026782@sss.pgh.pa.us>
References: <20080320134208.42400@gmx.net>
<9890.1206025894@sss.pgh.pa.us>
<20080320152034.190800@gmx.net>
<10458.1206026782@sss.pgh.pa.us>
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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: petersjan@gmx.at, tgl@sss.pgh.pa.us
Subject: Re: Rollback locks table - why?
In-Reply-To: <20080320153723.113670@gmx.net>
* 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