But how do you issue a ROLLBACK to a different pid?
You cannot. At that point you need to start from scratch.
pg_terminate_backend(pid int)
And let the problematic app deal with losing its database connection however it will.
David J.
But how do you issue a ROLLBACK to a different pid?