RE: select locks table for updates

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(at)2ndquadrant(dot)com>
Envoyé : jeudi 19 novembre 2020 22:14
À : Michel SALAIS <msalais(at)msym(dot)fr>
Cc : Yambu <hyambu(at)gmail(dot)com>; Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Objet : Re: select locks table for updates

On Thu, 19 Nov 2020 at 10:20, Michel SALAIS <msalais(at)msym(dot)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/