From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: anthony@berglas.org
Subject: Locking
Date: Thu, 14 Mar 2024 00:16:07 +0000
Message-ID: <171037536712.644.16792405319486797414@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/mvcc-intro.html
Description:
There really needs to be an explicit warning that the following is invalid
in normal read committed mode:-
select foo into f from bar where id=1;
f = f + 123;
update bar set foo = f where id =1;
commit;
This is a very common and serious mistake and extremely difficult to
understand from the current documentation.
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-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, anthony@berglas.org
Subject: Re: Locking
In-Reply-To: <171037536712.644.16792405319486797414@wrigleys.postgresql.org>
* 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