Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id BB8AE1337BBB
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 17 Feb 2011 22:16:35 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 19417-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 18 Feb 2011 02:16:30 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com
	[209.85.160.46])
	by mail.postgresql.org (Postfix) with ESMTP id 00E381337B4F
	for <pgsql-admin@postgresql.org>; Thu, 17 Feb 2011 22:16:27 -0400 (AST)
Received: by pwj3 with SMTP id 3so518091pwj.19
	for <pgsql-admin@postgresql.org>; Thu, 17 Feb 2011 18:16:27 -0800 (PST)
Received: by 10.142.49.16 with SMTP id w16mr116259wfw.218.1297995038531;
	Thu, 17 Feb 2011 18:10:38 -0800 (PST)
Received: from Issac.consistentstate.com (c-67-165-192-103.hsd1.co.comcast.net
	[67.165.192.103])
	by mx.google.com with ESMTPS id p40sm2063765wfc.5.2011.02.17.18.10.37
	(version=SSLv3 cipher=OTHER); Thu, 17 Feb 2011 18:10:37 -0800 (PST)
Message-ID: <4D5DD51C.30600@consistentstate.com>
Date: Thu, 17 Feb 2011 19:10:36 -0700
From: CS DBA <cs_dba@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.13) Gecko/20101208 Red Hat/3.1.7-3.el6_0 Lightning/1.0b2
	Thunderbird/3.1.7
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: finding the procpid (or pid) for a prepared transaction
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.6 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201102/165
X-Sequence-Number: 36804

Hi All;

I have several prepared tx which are running for a long long time. I 
want to kill 'em but I dont know the process id. I can get the xid via 
pg_prepared_xacts.transaction however the tx's have no locks thus no 
corresponding pg_locks row.  Anyone know how I can get a procpid based 
on a tx id?


Thanks in advance...