pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Michel SALAIS <msalais@msym.fr>
To: 'Yambu' <hyambu@gmail.com>
To: 'Pgsql-admin' <pgsql-admin@lists.postgresql.org>
Subject: RE: select locks table for updates
Date: Thu, 19 Nov 2020 11:19:59 +0100
Message-ID: <01b901d6be5d$8952cfb0$9bf86f10$@msym.fr> (raw)
In-Reply-To: <CALhHtcCVbvXq+6Ekv7RE91XPb=vLYvY2patRFv91SLAQzN4oHw@mail.gmail.com>
References: <CALhHtcCVbvXq+6Ekv7RE91XPb=vLYvY2patRFv91SLAQzN4oHw@mail.gmail.com>

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?

view thread (5+ messages)  latest in thread

Message-ID: <01b901d6be5d$8952cfb0$9bf86f10$@msym.fr>
Permalink:  ../01b901d6be5d$8952cfb0$9bf86f10$@msym.fr/
Also on:    postgresql.org/message-id/01b901d6be5d$8952cfb0$9bf86f10$@msym.fr

copy link · copy postgr.es

reply

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, hyambu@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: RE: select locks table for updates
  In-Reply-To: <01b901d6be5d$8952cfb0$9bf86f10$@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