Message-ID: <914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at>
Subject: Re: Documentation should state what happens, when a commit fails
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dave Cramer <davecramer@postgres.rocks>, "David G. Johnston"
	 <david.g.johnston@gmail.com>
Cc: mark maker <mark@makr.zone>, "pgsql-docs@lists.postgresql.org"
	 <pgsql-docs@lists.postgresql.org>
Date: Wed, 28 May 2025 20:49:52 +0200
In-Reply-To: 
 <CADK3HH+b3dWpMGvSUUArLO62hHAGY+qaF1kCDBaK0KbC-yAJ7Q@mail.gmail.com>
References: <174841970441.781.9104306922623804710@wrigleys.postgresql.org>
	 <aef9d51eeb3a60adf3b7d61e14aed0228ca22db0.camel@cybertec.at>
	 <CAKFQuwbjPfjOu18aiQrCexK16V8Jw42K9NvzHKxRipSPsqmpTg@mail.gmail.com>
	 <248747ba-1626-4840-8106-f9598275616f@makr.zone>
	 <CAKFQuwYATsj3cY6gOu_yWxcm4qSEspNvmVm=nvXmYBs0vseHzw@mail.gmail.com>
	 <CADK3HH+b3dWpMGvSUUArLO62hHAGY+qaF1kCDBaK0KbC-yAJ7Q@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/914d62974974a73595cdebb30db1634a14615dc9.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-05-28 at 11:09 -0400, Dave Cramer wrote:
> Somewhat annoying feature of this behaviour is that when COMMIT is issued=
 on an aborted transaction no error is reported.
> Most drivers work around this problem by keeping track of the previous er=
ror and reporting an error on the COMMIT.

We have been there before:
https://postgr.es/m/b9fb50dc-0f6e-15fb-6555-8ddb86f4aa71%40postgresfriends.=
org
Nothing came of that discussion though.

Yours,
Laurenz Albe