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

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 31 Dec 2019 12:08:32 -0600



    On 12/31/19 11:29 AM, David G. Johnston wrote:

    
      On Tuesday, December 31, 2019, Ron <ronljohnsonjr@xxxxxxxxx>
      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.