From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Robert Treat <rob@xzilla.net>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: Erik Rijkers <er@xs4all.nl>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: New docs chapter on Transaction Management and related changes
Date: Mon, 21 Nov 2022 11:35:09 +0100
Message-ID: <20221121103509.3sruif2h3msjsbw3@alvherre.pgsql> (raw)
In-Reply-To: <07d63204be526d4c74c322c3f1646e76e5ba3910.camel@cybertec.at>
Agreed on not using "unaborted", per previous discussion.
On 2022-Nov-21, Laurenz Albe wrote:
> Perhaps we should also avoid the term "transaction block". Even without speaking
> of a "block", way too many people confuse PL/pgSQL's BEGIN ... END blocks
> with transactions. On the other hand, we use "transaction block" everywhere
> else in the documentation...
Yeah, I don't understand why we need this "transaction block" term at
all. It adds nothing. We could just use the term "transaction", and
little meaning would be lost. When necessary, we could just say
"explicit transaction" or something to that effect. In this particular
case, we could modify your proposed wording,
> <para>
> Multi-statement transactions can be created explicitly using
> <command>BEGIN</command> or <command>START TRANSACTION</command> and
> are ended using <command>COMMIT</command> or <command>ROLLBACK</command>.
> An SQL statement outside of a transaction block automatically uses
> a single-statement transaction.
> </para>
by removing the word "block":
> Any SQL statement outside of an transaction automatically uses
> a single-statement transaction.
and perhaps add "explicit", but I don't think it's necessary:
> Any SQL statement outside of an explicit transaction automatically
> uses a single-statement transaction.
(I also changed "An" to "Any" because it seems more natural, but I
suppose it's a stylistic choice.)
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, laurenz.albe@cybertec.at, bruce@momjian.us, rob@xzilla.net, simon.riggs@enterprisedb.com, er@xs4all.nl, pryzby@telsasoft.com
Subject: Re: New docs chapter on Transaction Management and related changes
In-Reply-To: <20221121103509.3sruif2h3msjsbw3@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox