From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Document How Commit Handles Aborted Transactions |
Date: | 2024-12-20 16:02:55 |
Message-ID: | CAKFQuwYgYR3rWt6vFXw=ZWZ__bv7PqvdOnHujG+UyqE11f+3sg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
The commit reference page lacks an "Outputs" section even though it is
capable of outputting both "COMMIT" and "ROLLBACK".
The attached adds this section, describes when each applies, and then
incorporates the same into the main description for commit as well as the
transaction section of the tutorial - which presently seems to be the main
discussion area for the topic (the Concurrency Control chapter lacks a
section for this introductory material).
This was noted as being needed by Tom Lane back into 2006 but it
never happened.
https://www.postgresql.org/message-id/28798.1142608067%40sss.pgh.pa.us
It came up again when I was answering a question on Slack regarding "commit
and chain" wondering whether the "and chain" could be made conditional
(i.e., could the new transaction start aborted) on whether commit outputted
"commit" or "rollback".
Its left implied that this behavior of "rollback" is standard-conforming.
Please feel free to suggest/add language to the Compatibility section if
this is not the case.
David J.
Attachment | Content-Type | Size |
---|---|---|
0001-doc-Commit-performs-rollback-of-aborted-transactions.patch | text/x-patch | 4.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2024-12-20 16:39:42 | Re: FileFallocate misbehaving on XFS |
Previous Message | David Steele | 2024-12-20 15:37:36 | Fix logging for invalid recovery timeline |