Re: Document How Commit Handles Aborted Transactions

Kirill Reshke <reshkekirill@gmail.com>

From: Kirill Reshke <reshkekirill@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Ahmed Ashour <a8087027@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-08-22T13:17:01Z
Lists: pgsql-hackers
On Thu, 29 May 2025 at 04:32, David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> Recent discussion led me to realize we are also contrary to the SQL Standard here.  v3 updates the Commit reference page to reflect this fact.
>
> Leaving ready-to-commit.
>
> David J.
>

Hi!
I reviewed your changes and I agree with them.

The only aspect that drew my attention is in the following sentence:

>+ but instead goes into an aborted state. While in this state all commands except
> +    <xref linkend="sql-commit"/> and <xref linkend="sql-rollback"/> are ignored

We can also do ABORT;

Is this worth noting?

-- 
Best regards,
Kirill Reshke



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Doc: commit performs rollback of aborted transactions.