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

2020-01-07 Thread Laurenz Albe
On Tue, 2019-12-31 at 06:55 +0100, Matthias Apitz wrote: > Due to a wrong human input in the GUI of our application our > application server, from the point of view of the PostgreSQL server it > is the PostgreSQL client, issues a broken ESQL/C command to the PostgreSQL > server, here from our own d

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

2020-01-01 Thread Matthias Apitz
El día martes, diciembre 31, 2019 a las 10:06:22a. m. +, Patrick FICHE escribió: > Hi, > > Which behavior are you looking for ? > If you want the following statements to succeed, I guess that you don't want > to be in a transaction context. > In this case, you should have a look at the foll

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

2019-12-31 Thread Ron
On 12/31/19 11:29 AM, David G. Johnston wrote: On Tuesday, December 31, 2019, Ron > 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 problemati

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

2019-12-31 Thread David G. Johnston
On Tuesday, December 31, 2019, Ron 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.

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

2019-12-31 Thread Ron
On 12/31/19 3:40 AM, Guillaume Lelarge wrote: Le mar. 31 déc. 2019 à 06:55, Matthias Apitz > a écrit : Hello, Due to a wrong human input in the GUI of our application our application server, from the point of view of the PostgreSQL server it is the Post

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

2019-12-31 Thread Patrick FICHE
Hi, Which behavior are you looking for ? If you want the following statements to succeed, I guess that you don't want to be in a transaction context. In this case, you should have a look at the following link : https://www.postgresql.org/docs/11/ecpg-commands.html By default, the AUTOCOMMIT is O

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

2019-12-31 Thread Guillaume Lelarge
Le mar. 31 déc. 2019 à 06:55, Matthias Apitz a écrit : > > Hello, > > Due to a wrong human input in the GUI of our application our > application server, from the point of view of the PostgreSQL server it > is the PostgreSQL client, issues a broken ESQL/C command to the PostgreSQL > server, here f