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 1uuQso-009SGh-ND for pgsql-committers@arkaria.postgresql.org; Fri, 05 Sep 2025 07:29:19 +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 1uuQsn-005Jtq-Rn for pgsql-committers@arkaria.postgresql.org; Fri, 05 Sep 2025 07:29:18 +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.94.2) (envelope-from ) id 1uuQsn-005Jth-JX for pgsql-committers@lists.postgresql.org; Fri, 05 Sep 2025 07:29:18 +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.96) (envelope-from ) id 1uuQsm-000dmY-1D for pgsql-committers@lists.postgresql.org; Fri, 05 Sep 2025 07:29:17 +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.94.2) (envelope-from ) id 1uuQsl-001kKj-62 for pgsql-committers@lists.postgresql.org; Fri, 05 Sep 2025 07:29:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uuQsl-000aid-1R for pgsql-committers@lists.postgresql.org; Fri, 05 Sep 2025 07:29:15 +0000 Content-Type: multipart/mixed; boundary="===============5749003290378452825==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix concurrent update issue with MERGE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 05 Sep 2025 07:29:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5749003290378452825== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGNvbmN1cnJlbnQgdXBkYXRlIGlzc3VlIHdpdGggTUVSR0UuCgpXaGVuIGV4ZWN1dGluZyBh IE1FUkdFIFVQREFURSBhY3Rpb24sIGlmIHRoZXJlIGlzIG1vcmUgdGhhbiBvbmUKY29uY3VycmVu dCB1cGRhdGUgb2YgdGhlIHRhcmdldCByb3csIHRoZSBsb2NrLWFuZC1yZXRyeSBjb2RlIHdvdWxk CnNvbWV0aW1lcyBpbmNvcnJlY3RseSBpZGVudGlmeSB0aGUgbGF0ZXN0IHZlcnNpb24gb2YgdGhl IHRhcmdldCB0dXBsZSwKbGVhZGluZyB0byBpbmNvcnJlY3QgcmVzdWx0cy4KClRoaXMgd2FzIGNh dXNlZCBieSB1c2luZyB0aGUgY3RpZCBmaWVsZCBmcm9tIHRoZSBUTV9GYWlsdXJlRGF0YQpyZXR1 cm5lZCBieSB0YWJsZV90dXBsZV9sb2NrKCkgaW4gYSBjYXNlIHdoZXJlIHRoZSByZXN1bHQgd2Fz IFRNX09rLAp3aGljaCBpcyB1bnNhZmUgYmVjYXVzZSB0aGUgVE1fRmFpbHVyZURhdGEgc3RydWN0 IGlzIG5vdCBndWFyYW50ZWVkIHRvCmJlIGZ1bGx5IHBvcHVsYXRlZCBpbiB0aGF0IGNhc2UuIElu c3RlYWQsIGl0IHNob3VsZCB1c2UgdGhlIHR1cGxlaWQKcGFzc2VkIHRvIChhbmQgdXBkYXRlZCBi eSkgdGFibGVfdHVwbGVfbG9jaygpLgoKVG8gcmVkdWNlIHRoZSBjaGFuY2VzIG9mIHNpbWlsYXIg ZXJyb3JzIGluIHRoZSBmdXR1cmUsIGltcHJvdmUgdGhlCmNvbW1lbnRhcnkgZm9yIHRhYmxlX3R1 cGxlX2xvY2soKSBhbmQgVE1fRmFpbHVyZURhdGEgdG8gbWFrZSBpdApjbGVhcmVyIHRoYXQgdGFi bGVfdHVwbGVfbG9jaygpIHVwZGF0ZXMgdGhlIHRpZCBwYXNzZWQgdG8gaXQsIGFuZCBtb3N0CmZp ZWxkcyBvZiBUTV9GYWlsdXJlRGF0YSBzaG91bGQgbm90IGJlIHJlbGllZCBvbiBpbiBub24tZmFp bHVyZSBjYXNlcy4KQW4gZXhjZXB0aW9uIHRvIHRoaXMgaXMgdGhlICJ0cmF2ZXJzZWQiIGZpZWxk LCB3aGljaCBpcyBzZXQgaW4gYm90aApzdWNjZXNzIGFuZCBmYWlsdXJlIGNhc2VzLgoKUmVwb3J0 ZWQtYnk6IERtaXRyeSA8ZHN5LjA3NUB5YW5kZXgucnU+CkF1dGhvcjogWXVnbyBOYWdhdGEgPG5h Z2F0YUBzcmFvc3MuY28uanA+ClJldmlld2VkLWJ5OiBEZWFuIFJhc2hlZWQgPGRlYW4uYS5yYXNo ZWVkQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IENoYW8gTGkgPGxpLmV2YW4uY2hhb0BnbWFpbC5j b20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTU3MGQzMGUtMmI5NS00MjM5LWI5 YzMtZjdiZjJmMmY4NTU2QHlhbmRleC5ydQpCYWNrcGF0Y2gtdGhyb3VnaDogMTUKCkJyYW5jaAot LS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvYzcwYjZkYjM0ZmZlYWI0OGJlZWYxZmI0Y2U2MWJjYWQzNzcy YjhkZAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Iv bm9kZU1vZGlmeVRhYmxlLmMgICAgICAgICAgICAgfCAgIDkgKy0Kc3JjL2luY2x1ZGUvYWNjZXNz L3RhYmxlYW0uaCAgICAgICAgICAgICAgICAgICAgICAgfCAgMTUgKystCi4uLi9pc29sYXRpb24v ZXhwZWN0ZWQvbWVyZ2UtbWF0Y2gtcmVjaGVjay5vdXQgICAgIHwgMTQ1ICsrKysrKysrKysrKysr KysrKysrKwpzcmMvdGVzdC9pc29sYXRpb24vc3BlY3MvbWVyZ2UtbWF0Y2gtcmVjaGVjay5zcGVj ICB8ICAxOCArKysKNCBmaWxlcyBjaGFuZ2VkLCAxNzkgaW5zZXJ0aW9ucygrKSwgOCBkZWxldGlv bnMoLSkKCg== --===============5749003290378452825==--