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 1uch05-00FqiA-Iw for pgsql-committers@arkaria.postgresql.org; Fri, 18 Jul 2025 09:03:29 +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 1uch03-009fLt-Dt for pgsql-committers@arkaria.postgresql.org; Fri, 18 Jul 2025 09:03:28 +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 1uch03-009fLe-6F for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:27 +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 1uch01-007uZ2-1H for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:26 +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 1uch00-004SZ1-VY for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:24 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uch00-006tVE-0j for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:24 +0000 Content-Type: multipart/mixed; boundary="===============1684539777870498123==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix concurrent update trigger issues with MERGE in a CTE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 18 Jul 2025 09:03:24 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1684539777870498123== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGNvbmN1cnJlbnQgdXBkYXRlIHRyaWdnZXIgaXNzdWVzIHdpdGggTUVSR0UgaW4gYSBDVEUu CgpJZiBhIE1FUkdFIGluc2lkZSBhIENURSBhdHRlbXB0cyBhbiBVUERBVEUgb3IgREVMRVRFIG9u IGEgdGFibGUgd2l0aApCRUZPUkUgUk9XIHRyaWdnZXJzLCBhbmQgYSBjb25jdXJyZW50IFVQREFU RSBvciBERUxFVEUgaGFwcGVucywgdGhlCm1lcmdlIGNvZGUgd291bGQgZmFpbCAoY3Jhc2hpbmcg aW4gdGhlIGNhc2Ugb2YgYW4gVVBEQVRFIGFjdGlvbiwgYW5kCnBvdGVudGlhbGx5IGV4ZWN1dGlu ZyB0aGUgd3JvbmcgYWN0aW9uIGZvciBhIERFTEVURSBhY3Rpb24pLgoKVGhpcyBpcyB0aGUgc2Ft ZSBpc3N1ZSB0aGF0IDkzMjFjNzljODYgYXR0ZW1wdGVkIHRvIGZpeCwgZXhjZXB0IG5vdwpmb3Ig YSBNRVJHRSBpbnNpZGUgYSBDVEUuIEFzIG5vdGVkIGluIDkzMjFjNzljODYsIHdoYXQgbmVlZHMg dG8gaGFwcGVuCmlzIGZvciB0aGUgdHJpZ2dlciBjb2RlIHRvIGV4aXQgZWFybHksIHJldHVybmlu ZyB0aGUgVE1fUmVzdWx0IGFuZApUTV9GYWlsdXJlRGF0YSBpbmZvcm1hdGlvbiB0byB0aGUgbWVy Z2UgY29kZSwgaWYgYSBjb25jdXJyZW50Cm1vZGlmaWNhdGlvbiBpcyBkZXRlY3RlZCwgcmF0aGVy IHRoYW4gYXR0ZW1wdGluZyB0byBkbyBhbiBFUFEKcmVjaGVjay4gVGhlIG1lcmdlIGNvZGUgd2ls bCB0aGVuIGRvIGl0cyBvd24gcmVjaGVja2luZywgYW5kIHJlc2Nhbgp0aGUgYWN0aW9uIGxpc3Qs IHBvdGVudGlhbGx5IGV4ZWN1dGluZyBhIGRpZmZlcmVudCBhY3Rpb24gaW4gbGlnaHQgb2YKdGhl IGNvbmN1cnJlbnQgdXBkYXRlLiBJbiBwYXJ0aWN1bGFyLCB0aGUgdHJpZ2dlciBjb2RlIG11c3Qg bmV2ZXIgY2FsbApFeGVjR2V0VXBkYXRlTmV3VHVwbGUoKSBmb3IgTUVSR0UsIHNpbmNlIHRoYXQg aXMgYm91bmQgdG8gZmFpbCBiZWNhdXNlCk1FUkdFIGhhcyBpdHMgb3duIHBlci1hY3Rpb24gcHJv amVjdGlvbiBpbmZvcm1hdGlvbi4KCkNvbW1pdCA5MzIxYzc5Yzg2IGRpZCB0aGlzIHVzaW5nIGVz dGF0ZS0+ZXNfcGxhbm5lZHN0bXQtPmNvbW1hbmRUeXBlCmluIHRoZSB0cmlnZ2VyIGNvZGUgdG8g ZGV0ZWN0IHRoYXQgYSBNRVJHRSB3YXMgYmVpbmcgZXhlY3V0ZWQsIHdoaWNoCmlzIGZpbmUgZm9y IGEgcGxhaW4gTUVSR0UgY29tbWFuZCwgYnV0IGRvZXMgbm90IHdvcmsgZm9yIGEgTUVSR0UKaW5z aWRlIGEgQ1RFLiBGaXggYnkgcGFzc2luZyB0aGF0IGluZm9ybWF0aW9uIHRvIHRoZSB0cmlnZ2Vy IGNvZGUgYXMKYW4gYWRkaXRpb25hbCBwYXJhbWV0ZXIgcGFzc2VkIHRvIEV4ZWNCUlVwZGF0ZVRy aWdnZXJzKCkgYW5kCkV4ZWNCUkRlbGV0ZVRyaWdnZXJzKCkuCgpCYWNrLXBhdGNoIGFzIGZhciBh cyB2MTcgb25seSwgc2luY2UgTUVSR0UgY2Fubm90IGFwcGVhciBpbnNpZGUgYSBDVEUKcHJpb3Ig dG8gdGhhdC4gQWRkaXRpb25hbGx5LCB0YWtlIGNhcmUgdG8gcHJlc2VydmUgdGhlIHRyaWdnZXIg QUJJIGluCnYxNyAodGhvdWdoIG5vdCBpbiB2MTgsIHdoaWNoIGlzIHN0aWxsIGluIGJldGEpLgoK QnVnOiAjMTg5ODYKUmVwb3J0ZWQtYnk6IFlhcm9zbGF2IFN5cnl0c2lhIDxtZUB5cy5sYz4KQXV0 aG9yOiBEZWFuIFJhc2hlZWQgPGRlYW4uYS5yYXNoZWVkQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6 IE1pY2hhZWwgUGFxdWllciA8bWljaGFlbEBwYXF1aWVyLnh5ej4KRGlzY3Vzc2lvbjogaHR0cHM6 Ly9wb3N0Z3IuZXMvbS8xODk4Ni1lN2E4YWFjM2QzMzlmYTQ3QHBvc3RncmVzcWwub3JnCkJhY2tw YXRjaC10aHJvdWdoOiAxNwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzUwMjJmZjI1MGVlYmEyMzY3 ZmI0ZTc0ZmVkOGVlNjViY2RkYjZjOTkKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNy Yy9iYWNrZW5kL2NvbW1hbmRzL3RyaWdnZXIuYyAgICAgICAgICAgICAgICAgICAgIHwgNzQgKysr KysrKysrKysrKystLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9leGVjUmVwbGljYXRpb24u YyAgICAgICAgICAgICB8ICA0ICstCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL25vZGVNb2RpZnlUYWJs ZS5jICAgICAgICAgICAgIHwgIDYgKy0Kc3JjL2luY2x1ZGUvY29tbWFuZHMvdHJpZ2dlci5oICAg ICAgICAgICAgICAgICAgICAgfCAgNiArLQouLi4vaXNvbGF0aW9uL2V4cGVjdGVkL21lcmdlLW1h dGNoLXJlY2hlY2sub3V0ICAgICB8IDI3ICsrKysrLS0tCnNyYy90ZXN0L2lzb2xhdGlvbi9zcGVj cy9tZXJnZS1tYXRjaC1yZWNoZWNrLnNwZWMgIHwgMjIgKysrKy0tLQo2IGZpbGVzIGNoYW5nZWQs IDg5IGluc2VydGlvbnMoKyksIDUwIGRlbGV0aW9ucygtKQoK --===============1684539777870498123==--