On Wednesday, May 28, 2025, Laurenz Albe <laurenz.a...@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. https://commitfest.postgresql.org/patch/5546/ David J.
