Locking

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: anthony(at)berglas(dot)org
Subject: Locking
Date: 2024-03-14 00:16:07
Message-ID: 171037536712.644.16792405319486797414@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2024-03-15 07:29:19 Re: Locking
Previous Message Nacho Alonso Portillo 2024-03-13 15:21:39 Re: [EXTERNAL] Re: Definition of random_page_cost seems to invert correlation of that setting and seq_page_cost