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 1mG80O-0001Tb-H8 for pgsql-docs@arkaria.postgresql.org; Tue, 17 Aug 2021 22:56:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mG80N-00070u-GQ for pgsql-docs@arkaria.postgresql.org; Tue, 17 Aug 2021 22:56:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mG7ds-0000n1-Gj for pgsql-docs@lists.postgresql.org; Tue, 17 Aug 2021 22:33:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mG7dq-0007gT-27 for pgsql-docs@lists.postgresql.org; Tue, 17 Aug 2021 22:33:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=5zl4cC9wdbuKopJM3XFIzY717M8ILOv8RDBb7HYzSfk=; b=J/BzrbP9m9Lqp+xscECnnVRgEh 11DHk9thlcPt/c2+OpdVuoJjQVcOWyxSS0u9CeKHaHgLn9lITEiTLmvmiT9iQEI12MV2KmTww81+A 3BNXAYaUsdq2oqblI3Q4BA8A659KsJ3cG09nE1crPKUKpv2vT4zr0gz25VCQX55COup/pD2oSTV/g cOqzQY4t4Z6PAazGjF37VxBu9TJYTqcnO8KIoT6jbMx5+EUzE6de++t5J4Xn6PAk7bXi5S2rLIAn1 WOMw4VGzq6i3Tl9HraAiF168yEj16yo02OynZxiYk5RTZCrGQmkJ8SmTlbGQQnlZcKE1zrwK4u/8u i3OVyxEQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mG7do-00026e-SI for pgsql-docs@lists.postgresql.org; Tue, 17 Aug 2021 22:33:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mG7dm-000094-Cg for pgsql-docs@lists.postgresql.org; Tue, 17 Aug 2021 22:33:02 +0000 Content-Type: multipart/mixed; boundary="===============0384798336034697675==" MIME-Version: 1.0 Subject: Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level" To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: radiodiversion@gmail.com Reply-To: radiodiversion@gmail.com, pgsql-docs@lists.postgresql.org Date: Tue, 17 Aug 2021 22:32:42 +0000 Message-ID: <162923956240.1646.8016878483043252237@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0384798336034697675== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMy90cmFu c2FjdGlvbi1pc28uaHRtbApEZXNjcmlwdGlvbjoKCmhlbGxvIQ0KDQpkb2N1bWVudGF0aW9uIGZv ciAicmVhZCBjb21taXR0ZWQiIHNheXMgdGhhdDoNCg0KIlVQREFURSwgREVMRVRFLCBTRUxFQ1Qg Rk9SIFVQREFURSwgYW5kIFNFTEVDVCBGT1IgU0hBUkUgY29tbWFuZHMgLi4uDQouLi5JZiB0aGUg Zmlyc3QgdXBkYXRlciBjb21taXRzLCB0aGUgc2Vjb25kIHVwZGF0ZXIgd2lsbCBpZ25vcmUgdGhl IHJvdyBpZgp0aGUgZmlyc3QgdXBkYXRlciBkZWxldGVkIGl0LCBvdGhlcndpc2UgaXQgd2lsbCBh dHRlbXB0IHRvIGFwcGx5IGl0cwpvcGVyYXRpb24gdG8gdGhlIHVwZGF0ZWQgdmVyc2lvbiBvZiB0 aGUgcm93LiBUaGUgc2VhcmNoIGNvbmRpdGlvbiBvZiB0aGUKY29tbWFuZCAodGhlIFdIRVJFIGNs YXVzZSkgaXMgcmUtZXZhbHVhdGVkIHRvIHNlZSBpZiB0aGUgdXBkYXRlZCB2ZXJzaW9uIG9mCnRo ZSByb3cgc3RpbGwgbWF0Y2hlcyB0aGUgc2VhcmNoIGNvbmRpdGlvbi4iDQoNCmJ1dCB0aGlzIGJl aGF2aW91ciBpcyBub3QgcmVwcm9kdWNlZCBmb3IgVVBEQVRFIC4uIFdIRVJFIC4uDQp1cGRhdGUg ZnJvbSBzZWNvbmQgc2Vzc2lvbiBkb24ndCB0YWtlcyBpbnRvIGFjY291bnQgdXBkYXRlZCBkYXRh IGluIHJvdwpjb21taXR0ZWQgYnkgZmlyc3Qgc2Vzc2lvbi4NCg0KZXhhbXBsZToNCg0Kc2Vzc2lv bjE6IA0KICBiZWdpbjsNCiAgY3JlYXRlIHRhYmxlIHQgKCB4IG51bWVyaWMsIHkgbnVtZXJpYyAp Ow0KICBpbnNlcnQgaW50byB0IHZhbHVlcyAoIC0xLCAgMTEgKTsNCiAgaW5zZXJ0IGludG8gdCB2 YWx1ZXMgKCAgMSwgIDEyICk7DQogIGNvbW1pdDsgLS0gc28gdGFibGUgaXMgbm93IHZpc2libGUg Zm9yIGFub3RoZXIgdHJhbnNhY3Rpb25zDQogIGJlZ2luOw0KICB1cGRhdGUgdCBzZXQgeD0teCwg eT15KzEwMDsgLS0gaGVyZSByb3dzIGlzIGxvY2tlZCBieSBzZXNzaW9uMSB1bnRpbApjb21taXRc cm9sbGJhY2sNCg0Kc2Vzc2lvbiAyDQogIGJlZ2luOw0KICB1cGRhdGUgdCBzZXQgeT15KzEwMDAg d2hlcmUgeDwwOyAtLSBoZXJlIHNlc3Npb24yIHN0YXJ0IHdhaXRpbmcgZm9yCnNlc3Npb24xIGNv bW1pdFxyb2xsYmFjaw0KDQpzZXNzaW9uMQ0KICBjb21taXQ7DQoNCnNlc3Npb24yDQogIC0tIHN1 Y2Nlc3NmdWxseSBjb21wbGV0ZWQuIE5PIFJPV1MgQUZGRUNURUQhIA0KICAtLSB0aGlzIG1lYW5z IHRoYXQgdXBkYXRlIGZyb20gc2Vzc2lvbjIgd29ya3MgZGVmaW5pdGVseSBub3QgbGlrZQpkZXNj cmliZWQgaW4gZG9jdW1lbnRhdGlvbiAoIlRoZSBzZWFyY2ggY29uZGl0aW9uIG9mIHRoZSBjb21t YW5kICh0aGUgV0hFUkUKY2xhdXNlKSBpcyByZS1ldmFsdWF0ZWQiKQ0KDQpJIHdvdWxkIGxpa2Ug dG8gc2VlIGluIGRvY3VtZW50YXRpb24gZGVzY3JpcHRpb24gb2YgUkVBTCBiZWhhdmlvdXIgb2YK cG9zdGdyZXMgZm9yICJzZWNvbmQgdXBkYXRlciIuDQpPciwgbWF5YmUsIGl0J3MgYSBidWcuLiBi dXQgaXQncyBhIHByaW5jaXBhbCBwYXJ0IG9mIGlzb2xhdGlvbiBtZWNoYW5pc20sIHNvCmkgdGhp bmsgdGhhdCBpdCdzIGp1c3QgYSBkb2N1bWVudGF0aW9uIGlzc3VlLg0KDQppIHRha2UgZXhhbXBs ZSBmcm9tIGhlcmU6Cmh0dHBzOi8vZnJhbmNrcGFjaG90Lm1lZGl1bS5jb20vcmVhZC1jb21taXR0 ZWQtYW5vbWFsaWVzLWluLXBvc3RncmVzcWwtZjBkODAzMzBhMGUwCg0KaXQncyByZXByb2R1Y2Vk IG9uIFBvc3RncmVTUUwgMTMuMyAoRGViaWFuIDEzLjMtMS5wZ2RnMTAwKzEpDQoNCm1hbnkgdGhh bmtzIQo= --===============0384798336034697675==--