Message-ID: <47b356914fd6ccfd828ffd62d00ff2bfce37f076.camel@cybertec.at>
Subject: Re: How to cleanup transaction after statement_timeout aborts a
 query?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Istvan Soos <istvan.soos@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Date: Sun, 08 Sep 2024 16:18:32 +0200
In-Reply-To: <CALdQGgvBTFq1mOHY1GZ2t-h1x0Tjw+-HuOkZshTD7GTHdWowwQ@mail.gmail.com>
References: 
	<CALdQGgv_an=JdfkomND7sJcuAS1L5OmbFzhQa9qcW48syTXyKg@mail.gmail.com>
	 <8fabad5643b3b10355c95e30f4e758c17640d0d0.camel@cybertec.at>
	 <CALdQGgtteEQYNWhT80gNG3xSsjw+p1xDhFiG-+CUMXR9Gy=wBg@mail.gmail.com>
	 <1643e5dbd663bbbc8f2458c8dab08da342529643.camel@cybertec.at>
	 <CALdQGgvBTFq1mOHY1GZ2t-h1x0Tjw+-HuOkZshTD7GTHdWowwQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/47b356914fd6ccfd828ffd62d00ff2bfce37f076.camel%40cybertec.at>
Precedence: bulk

On Sun, 2024-09-08 at 16:02 +0200, Istvan Soos wrote:
> On Sun, Sep 8, 2024 at 3:41=E2=80=AFPM Laurenz Albe <laurenz.albe@cyberte=
c.at> wrote:
> > You must be doing something wrong then, because it works:
>=20
> And you are right, I was doing something wrong:
>=20
> [...]
>=20
> 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