Postgres Pro
Downloads
Home   >   mailing lists

Re: How to cleanup transaction after statement_timeout aborts a query? - Mailing list pgsql-general

From Istvan Soos
Subject Re: How to cleanup transaction after statement_timeout aborts a query?
Date
Msg-id CALdQGgvBTFq1mOHY1GZ2t-h1x0Tjw+-HuOkZshTD7GTHdWowwQ@mail.gmail.com
Whole thread Raw
In response to Re: How to cleanup transaction after statement_timeout aborts a query?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: How to cleanup transaction after statement_timeout aborts a query?
List pgsql-general
Tree view 
On Sun, Sep 8, 2024 at 3:41 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> You must be doing something wrong then, because it works:

And you are right, I was doing something wrong:

The combination of the change and the library internals triggered a
SET statement_timeout TO 3000; before the ROLLBACK was sent, and the
error message I got was not clear on which statement triggered it.

I'm sorry for the noise.

Btw. Is there any guideline on how to write the client libraries or
recommendations/tests that a client library should follow?

Thanks,
  Istvan

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: How to cleanup transaction after statement_timeout aborts a query?
Next
From: Laurenz Albe
Date:
Subject: Re: How to cleanup transaction after statement_timeout aborts a query?