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

Ron <[email protected]> Tue, 31 Dec 2019 12:08:32 -0600

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<[email protected]>

On 12/31/19 11:29 AM, David G. Johnston wrote:
> On Tuesday, December 31, 2019, Ron <[email protected] 
> <mailto:[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.

That's what I thought (and privately told OP).


-- 
Angular momentum makes the world go 'round.