From: Michel SALAIS <msalais@msym.fr>
To: 'Simon Riggs' <simon@2ndquadrant.com>
Cc: 'Yambu' <hyambu@gmail.com>
Cc: 'Pgsql-admin' <pgsql-admin@lists.postgresql.org>
Subject: RE: select locks table for updates
Date: Thu, 19 Nov 2020 23:31:59 +0100
Message-ID: <003601d6bec3$cc0db980$64292c80$@msym.fr> (raw)
In-Reply-To: <CANP8+j+OWE7+HtegL=N+gxPLdifRDYoveUuX2qYyDYUgD9hdPQ@mail.gmail.com>
References: <CALhHtcCVbvXq+6Ekv7RE91XPb=vLYvY2patRFv91SLAQzN4oHw@mail.gmail.com>
<01b901d6be5d$8952cfb0$9bf86f10$@msym.fr>
<CANP8+j+OWE7+HtegL=N+gxPLdifRDYoveUuX2qYyDYUgD9hdPQ@mail.gmail.com>
I think the original question wasn't about what can be done. Any way that is how I considered it. A simple question, a simple reply taking into account default behavior only. The point was just to say that things don't go the same everywhere...
Michel SALAIS
-----Message d'origine-----
De : Simon Riggs <simon@2ndquadrant.com>
Envoyé : jeudi 19 novembre 2020 22:14
À : Michel SALAIS <msalais@msym.fr>
Cc : Yambu <hyambu@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Objet : Re: select locks table for updates
On Thu, 19 Nov 2020 at 10:20, Michel SALAIS <msalais@msym.fr> wrote:
>
> No! Not in PostgreSQL.
In normal SELECTs, that is correct.
If you use SELECT ... FOR UPDATE then rows will be locked.
--
Simon Riggs http://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-admin@postgresql.org
Cc: msalais@msym.fr, simon@2ndquadrant.com, hyambu@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: select locks table for updates
In-Reply-To: <003601d6bec3$cc0db980$64292c80$@msym.fr>
* 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