pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dave Cramer <davecramer@postgres.rocks>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: mark maker <mark@makr.zone>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Documentation should state what happens, when a commit fails
Date: Wed, 28 May 2025 20:49:52 +0200
Message-ID: <914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at> (raw)
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>

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 error 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





view thread (7+ messages)

Message-ID: <914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at>
Permalink:  ../914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at/
Also on:    postgresql.org/message-id/914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: laurenz.albe@cybertec.at, davecramer@postgres.rocks, david.g.johnston@gmail.com, mark@makr.zone, pgsql-docs@lists.postgresql.org
  Subject: Re: Documentation should state what happens, when a commit fails
  In-Reply-To: <914d62974974a73595cdebb30db1634a14615dc9.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox