Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s8ISK-00BYip-Kv for pgsql-bugs@arkaria.postgresql.org; Sat, 18 May 2024 11:42:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s8ISJ-005KXu-Ld for pgsql-bugs@arkaria.postgresql.org; Sat, 18 May 2024 11:42:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7zcu-00EpGi-RS for pgsql-bugs@lists.postgresql.org; Fri, 17 May 2024 15:36:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7zcr-000jOV-5V for pgsql-bugs@lists.postgresql.org; Fri, 17 May 2024 15:36: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=b8j7kWDuFQlHCkrJiJJVC+FZ2VjTDgAlt61YFxQ/pq0=; b=NHBoZF6PYC2IUmZ6ejzNmaLYtl byOyQ2xiJp5hjLy+kYuo92RRn+JgIM7hL9zbBbIPII1KnRRXdc3yTzWMsZusVRxdoU20SbsxetDqZ 7/7O/lqMAZMTlkZO1MTLoUTTEa3vvMxLW2JpzzBtB6rVrPMQevdr/ThO5HOlwesVX90i8FBQ6nI+w bOmC0EFc6G6JdvyOvf/Cd60BUj58RhlRQ7JIv7O85/uoIZ4e3Yj6DD3q9AY9crQ6t0/yGbgpA+7K4 SR72XbilmaydoF8oe6P1917clRISSqpTly8U30BEMSB5urvmgVYu4iNGXM9bB6yWoRWaU2iwkN+wt BuW1jc2w==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7zcq-0026Xl-KQ for pgsql-bugs@lists.postgresql.org; Fri, 17 May 2024 15:36:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7zco-003YFp-4g for pgsql-bugs@lists.postgresql.org; Fri, 17 May 2024 15:36:02 +0000 Content-Type: multipart/mixed; boundary="===============7735255275408014599==" MIME-Version: 1.0 Subject: BUG #18472: SELECT FOR UPDATE locking more rows than expected To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: csteifel@gmail.com Reply-To: csteifel@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 17 May 2024 15:35:58 +0000 Message-ID: <18472-b6a2287713c0a40c@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 --===============7735255275408014599== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQ3MgpMb2dnZWQgYnk6ICAgICAgICAgIENvbGluIFN0ZWlmZWwKRW1h aWwgYWRkcmVzczogICAgICBjc3RlaWZlbEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4zCk9wZXJhdGluZyBzeXN0ZW06ICAgT2ZmaWNpYWwgZG9ja2VyIGNvbnRhaW5lciAxNi4zIHRh ZwpEZXNjcmlwdGlvbjogICAgICAgIAoKSSdtIHVzaW5nIHRoZSBmb2xsb3dpbmcgdG8gc2V0IHVw IHdoYXQgSSBiZWxpZXZlIHRvIGJlIHRoZSBpc3N1ZSBhdCBoYW5kOg0KDQoNCkNSRUFURSBUQUJM RSBJRiBOT1QgRVhJU1RTIHB1YmxpYy50YWIxDQooDQogICAgYSBpbnRlZ2VyIE5PVCBOVUxMLA0K ICAgIGIgaW50ZWdlciBOT1QgTlVMTA0KKTsNCg0KDQpDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNU UyBwdWJsaWMudGFiMg0KKA0KICAgIGFfcmVmIGludGVnZXIgTk9UIE5VTEwsDQogICAgYyBpbnRl Z2VyIE5PVCBOVUxMDQopOw0KDQpJTlNFUlQgSU5UTyBwdWJsaWMudGFiMSBWQUxVRVMgKDEsMSks KDIsMiksKDMsMyk7DQpJTlNFUlQgSU5UTyBwdWJsaWMudGFiMiBWQUxVRVMgKDEsNSksKDEsNiks KDEsNyksKDIsOCksKDIsOSksKDMsMTApOw0KDQoNCg0KDQpUaGVuIGluIHBnYWRtaW4gSSdtIG9w ZW5pbmcgdHdvIHF1ZXJ5IHRhYnMgZm9yIHRoZSBzYW1lIGRhdGFiYXNlIGFuZCBydW5uaW5nCnRo ZSBmb2xsb3dpbmcgaW4gdGFiIDENCg0KQkVHSU47DQpTRUxFQ1QgKg0KRlJPTSBwdWJsaWMudGFi MSB0MSwNCkxBVEVSQUwgKFNFTEVDVCAqIA0KRlJPTSBwdWJsaWMudGFiMg0KV0hFUkUgImEiPSJh X3JlZiIgDQpMSU1JVCAxDQopIHQyDQpPUkRFUiBCWSBiIEFTQw0KTElNSVQgMQ0KRk9SIFVQREFU RTsNCg0KDQpLZWVwaW5nIHRoZSB0cmFuc2FjdGlvbiBvcGVuIGFuZCBydW5uaW5nIHRoZSBmb2xs b3dpbmcgaW4gdGFiIDI6DQoNClNFTEVDVCAqIEZST00gcHVibGljLnRhYjIgRk9SIFVQREFURSBT S0lQIExPQ0tFRDsNCg0KDQpXaGF0IGlzIGhhcHBlbmluZzoNCkknbSBvbmx5IGdldHRpbmcgMyBy b3dzIGJhY2sgaW4gcXVlcnkgdGFiIDINCg0KV2hhdCBJJ20gZXhwZWN0aW5nOg0KRXhwZWN0aW5n IHRvIGdldCA1IHJvd3MgaW4gcXVlcnkgdGFiIDINCg0KDQpJZiBJIGNoYW5nZSB0aGUgb3JpZ2lu YWwgcXVlcnkgdG8gZWl0aGVyIHJlbW92ZSB0aGUgTElNSVQgY2xhdXNlIGluIHRoZQpzdWJxdWVy eSBlZzoNClNFTEVDVCAqDQpGUk9NIHB1YmxpYy50YWIxIHQxLA0KTEFURVJBTCAoU0VMRUNUICog DQpGUk9NIHB1YmxpYy50YWIyDQpXSEVSRSAiYSI9ImFfcmVmIiANCikgdDINCk9SREVSIEJZIGIg QVNDDQpMSU1JVCAxDQpGT1IgVVBEQVRFOw0KDQoNCg0KT3IgaWYgSSByZW1vdmUgdGhlIE9SREVS IEJZIGIgQVNDIGluIHRoZSB0b3AgbGV2ZWwgcXVlcnkgZWc6DQoNClNFTEVDVCAqDQpGUk9NIHB1 YmxpYy50YWIxIHQxLA0KTEFURVJBTCAoU0VMRUNUICogDQpGUk9NIHB1YmxpYy50YWIyDQpXSEVS RSAiYSI9ImFfcmVmIiANCkxJTUlUIDENCikgdDINCkxJTUlUIDENCkZPUiBVUERBVEU7DQoNCkFu ZCB0aGVuIHJldHJ5IEkgY2FuIHNlZSB0aGF0IEkgZ2V0IHRoZSBleHBlY3RlZCA1IHJvd3MgYmFj ayBpbiB0aGUgcXVlcnkKZnJvbSB0YWIgMiBsZWFkaW5nIG1lIHRvIGJlbGlldmUgdGhhdCB3aGVu IGJvdGggdGhlIExJTUlUIGFuZCBPUkRFUiBCWSBhcmUKcHJlc2VudCBwb3N0Z3JlcyBpcyBsb2Nr aW5nIG1vcmUgcm93cyB0aGFuIEkgYmVsaWV2ZSBzaG91bGQgYmUgbmVjZXNzYXJ5CmJhc2VkIG9u IHRoZSBkb2N1bWVudGF0aW9uIHRoYXQgSSd2ZSByZWFkIGFuZCBleHBlcmltZW50cyB0aGF0IEkn dmUgZG9uZS4NCg0KVGhhbmtzIGZvciB5b3VyIHRpbWUsDQpDb2xpbgoK --===============7735255275408014599==--