From: Laurenz Albe <laurenz.albe@cybertec.at>
To: mark@makr.zone
To: pgsql-docs@lists.postgresql.org
Subject: Re: Documentation should state what happens, when a commit fails
Date: Wed, 28 May 2025 15:06:01 +0200
Message-ID: <aef9d51eeb3a60adf3b7d61e14aed0228ca22db0.camel@cybertec.at> (raw)
In-Reply-To: <174841970441.781.9104306922623804710@wrigleys.postgresql.org>
References: <174841970441.781.9104306922623804710@wrigleys.postgresql.org>
On Wed, 2025-05-28 at 08:08 +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/sql-commit.html
> Description:
>
> Deferrable constraints, deadlocks and possibly other deferred or lazily
> evaluated rules are checked upon commit.
> What happens if they are not met and the commit statement fails? Does the
> transaction then implicitly rollback? Or do I need an explicit rollback?
I think it would be good to mention that a failed COMMIT automatically
performs a ROLLBACK. Do you want to suggest a patch?
Yours,
Laurenz Albe
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, mark@makr.zone, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation should state what happens, when a commit fails
In-Reply-To: <aef9d51eeb3a60adf3b7d61e14aed0228ca22db0.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