Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfh2u-0007hH-2P for pgsql-admin@arkaria.postgresql.org; Thu, 19 Nov 2020 10:20:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kfh2t-0003Bh-0K for pgsql-admin@arkaria.postgresql.org; Thu, 19 Nov 2020 10:20:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfh2s-0003Ba-PH for pgsql-admin@lists.postgresql.org; Thu, 19 Nov 2020 10:20:06 +0000 Received: from mout.kundenserver.de ([217.72.192.75]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kfh2q-0002fL-CI for pgsql-admin@lists.postgresql.org; Thu, 19 Nov 2020 10:20:05 +0000 Received: from ANAT ([82.253.128.121]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.184]) with ESMTPSA (Nemesis) id 1MMFZQ-1kvZCg1UaU-00JNEJ; Thu, 19 Nov 2020 11:20:00 +0100 From: "Michel SALAIS" To: "'Yambu'" , "'Pgsql-admin'" References: In-Reply-To: Subject: RE: select locks table for updates Date: Thu, 19 Nov 2020 11:19:59 +0100 Message-ID: <01b901d6be5d$8952cfb0$9bf86f10$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BA_01D6BE65.EB17FB00" X-Mailer: Microsoft Outlook 16.0 Content-Language: fr Thread-Index: AQKYEE4dpos6rE8Iap91JsG09J0k0qhMmfFQ X-Provags-ID: V03:K1:Tpmfhu5E3dCG//KMBff9Wcge6azBOQ5BfSAtkqM1of2A1OQg7D8 TVPHl3tSH09jpAQnqPyDuYDuhVZ88SqOvel3XakKBPCWHE7xTid4Glm8TYn6+dXs0bfeW67 XWFB6qiG9bA4JqglTkiyJk2BfiGbboA9n3PLfW+5kg1noVtu1MTiA35/ORJ/rS2axSGMyJ4 zs5VIFJTSCcVMoxaRBaHQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:QK/O8bt3PdI=:yxA8q9MGyNW8gcS1fe9vBM 0p9Aa/MiwmwFTBseZKu4eRUn27WUSjvFot7Lh+yqjIXRT3oL/CNH6pdt7HV+RckwklQeifY8T 4Sq6FhaLcTPP1+YTYhybs11AZ8O6utTI8HZqHSHmCQ3H28Hop2ov6OIMj9Wdld9FOCYzfhZ69 Dzb0Dxc/CGG4q5xaU24FJBexckkqSOgHtKJf2QTMf2pSwIIVY7FJDHph/R7Nlc09ZVUCweC6A EPj2ySCRMqr58cuTTnd7JrXvXrzeb2UEFofG8KEXkXzRmuvo737lTKdtPzqahUvJ5TQEBqVqa vt51oCbdSRCmA/lqvSeXm/d5MCtWXJknTNOJnMA4bCO+poGzF2x20WXwNdRvCf3EgsKpyOYxp QuLEZigZnLb13qe05AHfdNpAYymVrdwn5tvbGG72RFRz8ciZn4cjvbPKsjLnK List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_01BA_01D6BE65.EB17FB00 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable No! Not in PostgreSQL.=20 However it is true for SQL Server. =20 Michel SALAIS De : Yambu =20 Envoy=C3=A9 : jeudi 19 novembre 2020 11:07 =C3=80 : Pgsql-admin Objet : select locks table for updates =20 Hi =20 Does a select lock tables for updates? ------=_NextPart_000_01BA_01D6BE65.EB17FB00 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

No! Not in PostgreSQL. =

However it is true for SQL = Server.

 

Michel = SALAIS

De : Yambu = <hyambu@gmail.com>
Envoy=C3=A9 : jeudi 19 novembre = 2020 11:07
=C3=80 : Pgsql-admin = <pgsql-admin@lists.postgresql.org>
Objet : select = locks table for updates

 

Hi

 

Does a select lock tables for = updates?

------=_NextPart_000_01BA_01D6BE65.EB17FB00--