public inbox for [email protected]
help / color / mirror / Atom feedRe: How to cleanup transaction after statement_timeout aborts a query?
2+ messages / 2 participants
[nested] [flat]
* Re: How to cleanup transaction after statement_timeout aborts a query?
@ 2024-09-08 14:02 Istvan Soos <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Istvan Soos @ 2024-09-08 14:02 UTC (permalink / raw)
To: Laurenz Albe <[email protected]>; +Cc: [email protected]
On Sun, Sep 8, 2024 at 3:41 PM Laurenz Albe <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to cleanup transaction after statement_timeout aborts a query?
@ 2024-09-08 14:18 Laurenz Albe <[email protected]>
parent: Istvan Soos <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2024-09-08 14:18 UTC (permalink / raw)
To: Istvan Soos <[email protected]>; +Cc: [email protected]
On Sun, 2024-09-08 at 16:02 +0200, Istvan Soos wrote:
> On Sun, Sep 8, 2024 at 3:41 PM Laurenz Albe <[email protected]> wrote:
> > You must be doing something wrong then, because it works:
>
> And you are right, I was doing something wrong:
>
> [...]
>
> I'm sorry for the noise.
No problem; I'm glad you could find the stumbling stone.
> Btw. Is there any guideline on how to write the client libraries or
> recommendations/tests that a client library should follow?
I'm afraid this question is too generic for an answer...
I'd say it should be easy and intuitive to use, and should be as robust
as possible (return meaningful error messages rather than crash).
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-09-08 14:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-08 14:02 Re: How to cleanup transaction after statement_timeout aborts a query? Istvan Soos <[email protected]>
2024-09-08 14:18 ` Laurenz Albe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox