Re: Documentation should state what happens, when a commit fails

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: mark(at)makr(dot)zone, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Documentation should state what happens, when a commit fails
Date: 2025-05-28 13:06:01
Message-ID: aef9d51eeb3a60adf3b7d61e14aed0228ca22db0.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2025-05-28 14:04:45 Re: Documentation should state what happens, when a commit fails
Previous Message PG Doc comments form 2025-05-28 08:08:24 Documentation should state what happens, when a commit fails