Re: How to reset a server error '25P02 in_failed_sql_transaction'

"David G. Johnston" <[email protected]> Tue, 31 Dec 2019 10:29:02 -0700

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<CAKFQuwY+YQbBjA1SMpwTgO0RnJ6uz+mF9gaq5jvhhkudAzyPtw@mail.gmail.com>

On Tuesday, December 31, 2019, Ron <[email protected]> wrote:
>
> 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.