CS DBA <cs_...@consistentstate.com> writes: > 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.
If they're prepared, they're *not* running, and they don't have a
process id. They're just going to sit there until you do COMMIT
PREPARED or ROLLBACK PREPARED.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
