That depends on transaction isolation level. By default sql server doesn't use MVCC, so selects need shared locks. It's easily changed, though.
On Thu, 19 Nov 2020, 11:20 Michel SALAIS, <msalais@xxxxxxx> wrote:
No! Not in PostgreSQL.
However it is true for SQL Server.
Michel SALAIS
De : Yambu <hyambu@xxxxxxxxx>
Envoyé : jeudi 19 novembre 2020 11:07
À : Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Objet : select locks table for updates
Hi
Does a select lock tables for updates?
