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.96) (envelope-from ) id 1x6Qo6-000EG5-0E for pgsql-committers@arkaria.postgresql.org; Tue, 15 Sep 2026 10:54:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1x6Qo5-001QOm-0q for pgsql-committers@arkaria.postgresql.org; Tue, 15 Sep 2026 10:54:33 +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.96) (envelope-from ) id 1x6QlF-001NY2-2l for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:37 +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.98.2) (envelope-from ) id 1x6Ql9-00000000YXP-3m5R for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:37 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x6Ql9-000Uv9-1P for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:31 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x6Ql8-00000000QhQ-2kN2 for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:30 +0000 Content-Type: multipart/mixed; boundary="===============6277802169567201318==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix missing SIREAD lock on the row found by ON CONFLICT. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 15 Sep 2026 10:51:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6277802169567201318== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IG1pc3NpbmcgU0lSRUFEIGxvY2sgb24gdGhlIHJvdyBmb3VuZCBieSBPTiBDT05GTElDVC4K CklOU0VSVCAuLi4gT04gQ09ORkxJQ1QgZGVjaWRlcyB3aGF0IHRvIGRvIGJhc2VkIG9uIHRoZSBj b25mbGljdGluZyByb3cKZm91bmQgYnkgdGhlIGFyYml0ZXIgaW5kZXggcHJvYmUsIGJ1dCBTU0kg bmV2ZXIgc2F3IHRoYXQgcmVhZDogdGhlCnByb2JlIHJ1bnMgd2l0aCBhIGRpcnR5IHNuYXBzaG90 LCB3aGljaCBwcmVkaWNhdGUgbG9ja2luZyBpZ25vcmVzLCBhbmQKdGhlIGxhdGVyIGZldGNoIG9m IHRoZSByb3cgdXNlcyBTbmFwc2hvdEFueS4gIFdoZW4gdGhlIHN0YXRlbWVudCB0aGVuCndyaXRl cyBub3RoaW5nLCBhcyB3aXRoIERPIE5PVEhJTkcsIERPIFVQREFURSB3aXRoIGEgV0hFUkUgY2xh dXNlCnJlamVjdGluZyB0aGUgcm93LCBvciBETyBTRUxFQ1QsIG5vdGhpbmcgcmVjb3JkcyB0aGUg cmVhZCBhdCBhbGwuICBBCmNvbmN1cnJlbnQgd3JpdGVyIG9mIHRoYXQgcm93IHdlbnQgdW5ub3Rp Y2VkIGFuZCB3cml0ZSBza2V3IGNvdWxkCmNvbW1pdCBhdCBTRVJJQUxJWkFCTEUsIGV2ZW4gdGhv dWdoIHRoZSBzYW1lIHNjaGVkdWxlIHdpdGggYSBwbGFpbgpTRUxFQ1Qgb2YgdGhlIHJvdyBmYWls cyB3aXRoIGEgc2VyaWFsaXphdGlvbiBlcnJvci4KClRvIGZpeCwgcmVhZCB0aGUgY29uZmxpY3Rp bmcgdHVwbGUgYWdhaW4gd2l0aCB0aGUgcXVlcnkgc25hcHNob3QsCnJpZ2h0IHdoZXJlIHRoZSBw cm9iZSBmaW5kcyBpdC4gIFRoZSB0YWJsZSBBTSB0YWtlcyB0aGUgU0lSRUFEIGxvY2sKYW5kIGNo ZWNrcyBmb3IgYSBjb25jdXJyZW50IHdyaXRlciBvZiB0aGUgdHVwbGUgYXMgcGFydCBvZiB0aGF0 IHJlYWQsCmJvdGggdW5kZXIgdGhlIGJ1ZmZlciBsb2NrLCBzbyBhIHdyaXRlciBlaXRoZXIgc2Vl cyB0aGUgbG9jayBvciBpcwpzZWVuLiAgQSBwcmVkaWNhdGUgbG9jayBieSBpdHNlbGYgYWNxdWly ZWQgc2VwYXJhdGVseSBhZnRlciB0aGUgcHJvYmUKY291bGQgbm90IG9mZmVyIHRoYXQ6IGEgd3Jp dGVyIHBhc3NpbmcgaXRzIGNvbmZsaWN0IGNoZWNrIGluIGJldHdlZW4Kd291bGQgYmUgbWlzc2Vk LiAgRG9pbmcgdGhpcyBpbiB0aGUgcHJvYmUgY292ZXJzIGV2ZXJ5IGNvbmZsaWN0CmFjdGlvbiwg aW5jbHVkaW5nIHJvd3MgdGhhdCB0aGUgV0hFUkUgY2xhdXNlIG9mIERPIFVQREFURSBvciBETyBT RUxFQ1QKdGhlbiByZWplY3RzLgoKVGhlIERPIE5PVEhJTkcgYW5kIERPIFVQREFURSBjYXNlcyBo YXZlIGJlZW4gYnJva2VuIHNpbmNlIE9OIENPTkZMSUNUCndhcyBhZGRlZCBpbiA5LjU7IERPIFNF TEVDVCBpcyBuZXcgaW4gdjE5LiAgQmFja3BhdGNoIHRvIGFsbCBzdXBwb3J0ZWQKYnJhbmNoZXMu CgpBdXRob3I6IFpzb2x0IFBhcnJhZ2kgPHpzb2x0LnBhcnJhZ2lAcGVyY29uYS5jb20+CkF1dGhv cjogQW5kcmV5IEJvcm9kaW4gPHg0bW1tQHlhbmRleC10ZWFtLnJ1PgpSZXBvcnRlZC1ieTogQW5k cmV5IEJvcm9kaW4gPHg0bW1tQHlhbmRleC10ZWFtLnJ1PgpSZXBvcnRlZC1ieTogWnNvbHQgUGFy cmFnaSA8enNvbHQucGFycmFnaUBwZXJjb25hLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS83ODc5MzZDNS00MTU1LTRDRjktOTM5RC0zOURDMEVDMUM4OTJAeWFuZGV4LXRlYW0u cnUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQU40Q1pGTTFHa0hKa3BNZW80RzVy eHRhY1ZzZmVLQ0pZaWlrOUU5QUtYMUU5VllRMXdAbWFpbC5nbWFpbC5jb20KQmFja3BhdGNoLXRo cm91Z2g6IDE0CgpCcmFuY2gKLS0tLS0tClJFTF8xOF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzY1NjdmM2YxZjIxMzUzYjVi MGU5NTM4ZDA1ODk5OGFiNzZjNWEzN2MKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNJbmRleGluZy5jICAgICAgICAgICAgICAgIHwgMjAgKysr KysrKysrCi4uLi9leHBlY3RlZC9pbnNlcnQtY29uZmxpY3Qtc2VyaWFsaXphYmxlLm91dCAgICAg IHwgNDQgKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9pc29sYXRpb24vaXNvbGF0aW9uX3Nj aGVkdWxlICAgICAgICAgICAgICB8ICAxICsKLi4uL3NwZWNzL2luc2VydC1jb25mbGljdC1zZXJp YWxpemFibGUuc3BlYyAgICAgICAgfCA0OSArKysrKysrKysrKysrKysrKysrKysKc3JjL3Rlc3Qv bW9kdWxlcy9pbmplY3Rpb25fcG9pbnRzL01ha2VmaWxlICAgICAgICAgfCAgMyArLQouLi4vZXhw ZWN0ZWQvb25fY29uZmxpY3RfcHJvYmVfd2luZG93Lm91dCAgICAgICAgICB8IDM1ICsrKysrKysr KysrKysrKwpzcmMvdGVzdC9tb2R1bGVzL2luamVjdGlvbl9wb2ludHMvbWVzb24uYnVpbGQgICAg ICB8ICAxICsKLi4uL3NwZWNzL29uX2NvbmZsaWN0X3Byb2JlX3dpbmRvdy5zcGVjICAgICAgICAg ICAgfCA1MSArKysrKysrKysrKysrKysrKysrKysrCjggZmlsZXMgY2hhbmdlZCwgMjAzIGluc2Vy dGlvbnMoKyksIDEgZGVsZXRpb24oLSkKCg== --===============6277802169567201318==--