Re: Documentation should state what happens, when a commit fails - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Documentation should state what happens, when a commit fails
Date
Msg-id CAKFQuwbjPfjOu18aiQrCexK16V8Jw42K9NvzHKxRipSPsqmpTg@mail.gmail.com
Whole thread Raw
In response to Re: Documentation should state what happens, when a commit fails  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses RE: Documentation should state what happens, when a commit fails
List pgsql-docs
On Wednesday, May 28, 2025, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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?

Feel free to review mine for this topic and suggest additions.


David J.

pgsql-docs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Documentation should state what happens, when a commit fails
Next
From: mark maker
Date:
Subject: RE: Documentation should state what happens, when a commit fails