Home > mailing lists

Re: select locks table for updates - Mailing list pgsql-admin

From	Alexander Shelemin
Subject	Re: select locks table for updates
Date	November 19, 2020 13:27:46
Msg-id	CABokcfWJ58F+VQzOyTsjVz7a2owOpG+KGp9LhsKxbBmsd2jcCw@mail.gmail.com Whole thread Raw
In response to	RE: select locks table for updates ("Michel SALAIS" <msalais@msym.fr>)
List	pgsql-admin

Tree view

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@msym.fr> wrote:

No! Not in PostgreSQL.
However it is true for SQL Server.

Michel SALAIS
De : Yambu <hyambu@gmail.com>
Envoyé : jeudi 19 novembre 2020 11:07
À : Pgsql-admin <pgsql-admin@lists.postgresql.org>
Objet : select locks table for updates

Hi

Does a select lock tables for updates?

pgsql-admin by date:

From: "Michel SALAIS"
Date: 19 November 2020, 13:19:59
Subject: RE: select locks table for updates

From: Yambu
Date: 19 November 2020, 23:38:42
Subject: Logical replication

Re: select locks table for updates - Mailing list pgsql-admin

Previous

Next