Postgres Pro
Downloads
Home   >   mailing lists

Re: How to reset a server error '25P02 in_failed_sql_transaction' - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to reset a server error '25P02 in_failed_sql_transaction'
Date
Msg-id CAKFQuwY+YQbBjA1SMpwTgO0RnJ6uz+mF9gaq5jvhhkudAzyPtw@mail.gmail.com
Whole thread Raw
In response to Re: How to reset a server error '25P02 in_failed_sql_transaction'  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: How to reset a server error '25P02 in_failed_sql_transaction'
List pgsql-general
Tree view
On Tuesday, December 31, 2019, Ron <ronljohnsonjr@gmail.com> 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.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: How to reset a server error '25P02 in_failed_sql_transaction'
Next
From: Ron
Date:
Subject: Re: How to reset a server error '25P02 in_failed_sql_transaction'