CS DBA <cs_dba@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
