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...
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2011-02-18 02:19:24|
|Subject: Re: finding the procpid (or pid) for a prepared transaction |
|Previous:||From: Selva manickaraja||Date: 2011-02-18 01:43:00|
|Subject: Re: Trigger File Behaviour|