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 1whYGt-000IEZ-1k for pgsql-committers@arkaria.postgresql.org; Wed, 08 Jul 2026 19:49:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whYGq-0099ND-1I for pgsql-committers@arkaria.postgresql.org; Wed, 08 Jul 2026 19:49:25 +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.96) (envelope-from ) id 1whYGq-0099N5-0e for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 19:49:24 +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.98.2) (envelope-from ) id 1whYGn-00000000KqH-2ETx for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 19:49:24 +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 1whYGm-000hos-0c for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 19:49:20 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whYGl-000ByL-2E for pgsql-committers@lists.postgresql.org; Wed, 08 Jul 2026 19:49:20 +0000 Content-Type: multipart/mixed; boundary="===============5451175469264618323==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix RETURNING OLD with BEFORE UPDATE trigger and concurrent upda X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 08 Jul 2026 19:49:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5451175469264618323== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IFJFVFVSTklORyBPTEQgd2l0aCBCRUZPUkUgVVBEQVRFIHRyaWdnZXIgYW5kIGNvbmN1cnJl bnQgdXBkYXRlLgoKV2hlbiBleGVjdXRpbmcgYW4gVVBEQVRFIHdpdGggYSBSRVRVUk5JTkcgY2xh dXNlIG9uIGEgdGFibGUgd2l0aCBhCkJFRk9SRSBVUERBVEUgcm93IHRyaWdnZXIsIHRoZSBjb21w dXRhdGlvbiBvZiB0aGUgT0xEIHZhbHVlcyBpbiB0aGUKUkVUVVJOSU5HIGxpc3Qgd2FzIGluY29y cmVjdCBpZiB0aGUgdGFyZ2V0IHR1cGxlIHdhcyBjb25jdXJyZW50bHkKdXBkYXRlZCBieSBhbm90 aGVyIHNlc3Npb24sIGF0IGlzb2xhdGlvbiBsZXZlbCBSRUFEIENPTU1JVFRFRC4KClRoZSBwcm9i bGVtIHdhcyB0aGF0IHRoZSB0cmlnZ2VyIGNvZGUgd291bGQgbG9jayB0aGUgdGFyZ2V0IHR1cGxl LAp3YWl0aW5nIGZvciB0aGUgb3RoZXIgc2Vzc2lvbiB0byBjb21taXQsIGFuZCB0aGVuIGZldGNo IHRoZSB1cGRhdGVkCnRhcmdldCB0dXBsZSwgYnV0IEV4ZWNVcGRhdGUoKSB3b3VsZCBub3QgcmVh bGlzZSB0aGF0IHRoZSB0YXJnZXQgdHVwbGUKaGFkIGNoYW5nZWQsIGFuZCB1c2UgdGhlIG91dGRh dGVkIHRhcmdldCB0dXBsZSBmb3IgY29tcHV0aW5nIE9MRAp2YWx1ZXMuIEZpeCBieSBoYXZpbmcg RXhlY1VwZGF0ZSgpIGNoZWNrIHRoZSBUTV9GYWlsdXJlRGF0YSBmcm9tCnRyaWdnZXIgZXhlY3V0 aW9uIGFuZCByZS1mZXRjaCB0aGUgdGFyZ2V0IHR1cGxlIGlmIG5lY2Vzc2FyeS4KClJlLWZldGNo aW5nIHRoZSB0YXJnZXQgdHVwbGUgbGlrZSB0aGlzIGlzIGEgbGl0dGxlIGluZWZmaWNpZW50LCBi dXQKcHJvYmFibHkgbmVnbGlnaWJsZSBjb21wYXJlZCB0byB0aGUgdHJpZ2dlciBleGVjdXRpb24g YW5kIHVwZGF0ZS4gQQpiZXR0ZXIgbG9uZy10ZXJtIGZpeCBtaWdodCBiZSB0byBtb3ZlIHRoZSBF UFEgY29kZSBvdXQgb2YgdHJpZ2dlci5jLAphbmQgbGV0IEV4ZWNVcGRhdGUoKSBoYW5kbGUgaXQs IGxpa2UgRXhlY01lcmdlTWF0Y2hlZCgpIGRvZXMsIGJ1dCB0aGF0CndvdWxkIGxpa2VseSBtZWFu IGNoYW5naW5nIHRoZSB0cmlnZ2VyIEFQSSwgd2hpY2ggc2VlbXMgYSBiaXQgbXVjaCBmb3IKYmFj ay1wYXRjaGluZy4KCkJhY2twYXRjaCB0byB2MTgsIHdoZXJlIHN1cHBvcnQgZm9yIFJFVFVSTklO RyBPTEQvTkVXIHdhcyBhZGRlZC4KCkJ1ZzogIzE5NTM2ClJlcG9ydGVkLWJ5OiBKb25hcyBCb2Jl cmcgPGJvYmVyZ2pAZ21haWwuY29tPgpEaWFnbm9zZWQtYnk6IEJoYXJhdGggUnVwaXJlZGR5IDxi aGFyYXRoLnJ1cGlyZWRkeWZvcnBvc3RncmVzQGdtYWlsLmNvbT4KQXV0aG9yOiBEZWFuIFJhc2hl ZWQgPGRlYW4uYS5yYXNoZWVkQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEJoYXJhdGggUnVwaXJl ZGR5IDxiaGFyYXRoLnJ1cGlyZWRkeWZvcnBvc3RncmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjog aHR0cHM6Ly9wb3N0Z3IuZXMvbS8xOTUzNi03M2NlNTg0N2U2YzBlN2IxQHBvc3RncmVzcWwub3Jn CkJhY2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0tLS0tLQpSRUxfMTlfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi83MDQ4 ZTUwZjhmOTMwNTcxMjhkYjdlOGEwYTI5MjUyNDhmNzFhMjY2CgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9leGVjdXRvci9ub2RlTW9kaWZ5VGFibGUuYyAgICAgICAg ICAgICB8ICAxOSArKwouLi4vaXNvbGF0aW9uL2V4cGVjdGVkL2V2YWwtcGxhbi1xdWFsLXRyaWdn ZXIub3V0ICB8IDI1OCArKysrKysrKysrLS0tLS0tLS0tLS0KLi4uL2lzb2xhdGlvbi9leHBlY3Rl ZC9tZXJnZS1tYXRjaC1yZWNoZWNrLm91dCAgICAgfCAxNzkgKysrKysrKysrKysrLS0KLi4uL2lz b2xhdGlvbi9zcGVjcy9ldmFsLXBsYW4tcXVhbC10cmlnZ2VyLnNwZWMgICAgfCAgIDggKy0Kc3Jj L3Rlc3QvaXNvbGF0aW9uL3NwZWNzL21lcmdlLW1hdGNoLXJlY2hlY2suc3BlYyAgfCAgMjEgKy0K NSBmaWxlcyBjaGFuZ2VkLCAzMzMgaW5zZXJ0aW9ucygrKSwgMTUyIGRlbGV0aW9ucygtKQoK --===============5451175469264618323==--