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-00FrBe-S1 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-009hYa-UA for pgsql-committers@arkaria.postgresql.org; Fri, 18 Jul 2025 09:05:44 +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.94.2) (envelope-from ) id 1uch04-009fWS-KN for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:29 +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.96) (envelope-from ) id 1uch02-008PUr-2k for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:28 +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-004SZ3-Sr 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-006tVI-0p for pgsql-committers@lists.postgresql.org; Fri, 18 Jul 2025 09:03:24 +0000 Content-Type: multipart/mixed; boundary="===============3676246455663936253==" 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 --===============3676246455663936253== 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 YXRjaC10aHJvdWdoOiAxNwoKQnJhbmNoCi0tLS0tLQpSRUxfMTdfU1RBQkxFCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi85MWFkMWJkZWY4 ZTQ2OTgzZDgyZDI3MjNjNmUxYzA1ZTAwNGY3NGM1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90cmlnZ2VyLmMgICAgICAgICAgICAgICAgICAgICB8 IDEzNCArKysrKysrKysrKysrKystLS0tLS0Kc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZU1vZGlm eVRhYmxlLmMgICAgICAgICAgICAgfCAgMTQgKystCnNyYy9pbmNsdWRlL2NvbW1hbmRzL3RyaWdn ZXIuaCAgICAgICAgICAgICAgICAgICAgIHwgIDE4ICsrKwouLi4vaXNvbGF0aW9uL2V4cGVjdGVk L21lcmdlLW1hdGNoLXJlY2hlY2sub3V0ICAgICB8ICAyNyArKystLQpzcmMvdGVzdC9pc29sYXRp b24vc3BlY3MvbWVyZ2UtbWF0Y2gtcmVjaGVjay5zcGVjICB8ICAyMiArKy0tCjUgZmlsZXMgY2hh bmdlZCwgMTUzIGluc2VydGlvbnMoKyksIDYyIGRlbGV0aW9ucygtKQoK --===============3676246455663936253==--