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 1x6Qo5-000EG3-2l 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-0k for pgsql-committers@arkaria.postgresql.org; Tue, 15 Sep 2026 10:54:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1x6QlB-001NHc-3C for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:33 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x6Ql9-00000000AtJ-2a5U for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:33 +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-000UvA-0Y 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-00000000QhM-2bTv for pgsql-committers@lists.postgresql.org; Tue, 15 Sep 2026 10:51:30 +0000 Content-Type: multipart/mixed; boundary="===============4291293959826621234==" 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 --===============4291293959826621234== 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 cm91Z2g6IDE0CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZmI2MDg5MmY0MDM0MDE3ZTc3YjhkNDM3 NmQzY2E4OTM3ZGNiYmFiMgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tl bmQvZXhlY3V0b3IvZXhlY0luZGV4aW5nLmMgICAgICAgICAgICAgICAgfCAgMTkgKysrKwouLi4v ZXhwZWN0ZWQvaW5zZXJ0LWNvbmZsaWN0LXNlcmlhbGl6YWJsZS5vdXQgICAgICB8IDExNiArKysr KysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvaXNvbGF0aW9uL2lzb2xhdGlvbl9zY2hlZHVsZSAg ICAgICAgICAgICAgfCAgIDEgKwouLi4vc3BlY3MvaW5zZXJ0LWNvbmZsaWN0LXNlcmlhbGl6YWJs ZS5zcGVjICAgICAgICB8ICA3MSArKysrKysrKysrKysrCnNyYy90ZXN0L21vZHVsZXMvaW5qZWN0 aW9uX3BvaW50cy9NYWtlZmlsZSAgICAgICAgIHwgICAzICstCi4uLi9leHBlY3RlZC9vbl9jb25m bGljdF9wcm9iZV93aW5kb3cub3V0ICAgICAgICAgIHwgMTEzICsrKysrKysrKysrKysrKysrKysr CnNyYy90ZXN0L21vZHVsZXMvaW5qZWN0aW9uX3BvaW50cy9tZXNvbi5idWlsZCAgICAgIHwgICAx ICsKLi4uL3NwZWNzL29uX2NvbmZsaWN0X3Byb2JlX3dpbmRvdy5zcGVjICAgICAgICAgICAgfCAg NTcgKysrKysrKysrKwo4IGZpbGVzIGNoYW5nZWQsIDM4MCBpbnNlcnRpb25zKCspLCAxIGRlbGV0 aW9uKC0pCgo= --===============4291293959826621234==--