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@xxxxxxxxxxxxxxx> Envoyé : jeudi 19 novembre 2020 22:14 À : Michel SALAIS <msalais@xxxxxxx> Cc : Yambu <hyambu@xxxxxxxxx>; Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx> Objet : Re: select locks table for updates On Thu, 19 Nov 2020 at 10:20, Michel SALAIS <msalais@xxxxxxx> 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/
