Thomas Markus <t.markus@xxxxxxxxxxxxx> writes: > a rollback prepared on these does the job If you aren't intentionally using prepared transactions, it's a good idea to disable them by setting max_prepared_transactions to zero (DB restart required). That prevents you from accidentally shooting yourself in the foot like this. 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