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 1uch2H-00FrBf-S3 for pgsql-committers@arkaria.postgresql.org; Fri, 18 Jul 2025 09:05:45 +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 1uch2F-009hYZ-UA for pgsql-committers@arkaria.postgresql.org; Fri, 18 Jul 2025 09:05:44 +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-009fLf-7S 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-007uZ3-1k 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-004SZ2-VX 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-006tVG-0m for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:24 +0000 Content-Type: multipart/mixed; boundary="===============8040796720042428545==" 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 --===============8040796720042428545== 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 YXRjaC10aHJvdWdoOiAxNwoKQnJhbmNoCi0tLS0tLQpSRUxfMThfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yN2M3YzExMzY2 ZjcyYjE5MzNlMjk4NDgxOTU0YTI0Yzc0MjAzNmRlCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMgICAgICAgICAgICAgICAgICAgICB8 IDc0ICsrKysrKysrKysrKysrLS0tLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3IvZXhlY1JlcGxp Y2F0aW9uLmMgICAgICAgICAgICAgfCAgNCArLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlTW9k aWZ5VGFibGUuYyAgICAgICAgICAgICB8ICA2ICstCnNyYy9pbmNsdWRlL2NvbW1hbmRzL3RyaWdn ZXIuaCAgICAgICAgICAgICAgICAgICAgIHwgIDYgKy0KLi4uL2lzb2xhdGlvbi9leHBlY3RlZC9t ZXJnZS1tYXRjaC1yZWNoZWNrLm91dCAgICAgfCAyNyArKysrKy0tLQpzcmMvdGVzdC9pc29sYXRp b24vc3BlY3MvbWVyZ2UtbWF0Y2gtcmVjaGVjay5zcGVjICB8IDIyICsrKystLS0KNiBmaWxlcyBj aGFuZ2VkLCA4OSBpbnNlcnRpb25zKCspLCA1MCBkZWxldGlvbnMoLSkKCg== --===============8040796720042428545==--