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 1vPKBq-00FKp8-0t for pgsql-committers@arkaria.postgresql.org; Sat, 29 Nov 2025 12:36:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vPKBn-00Eccb-07 for pgsql-committers@arkaria.postgresql.org; Sat, 29 Nov 2025 12:36:35 +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.96) (envelope-from ) id 1vPKBm-00EccM-2c for pgsql-committers@lists.postgresql.org; Sat, 29 Nov 2025 12:36:35 +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 1vPKBj-002C2n-2O for pgsql-committers@lists.postgresql.org; Sat, 29 Nov 2025 12:36:33 +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 1vPKBj-002XqE-2Q for pgsql-committers@lists.postgresql.org; Sat, 29 Nov 2025 12:36:31 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vPKBi-001yFw-2X for pgsql-committers@lists.postgresql.org; Sat, 29 Nov 2025 12:36:31 +0000 Content-Type: multipart/mixed; boundary="===============4822774308217436905==" MIME-Version: 1.0 From: Dean Rasheed To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid rewriting data-modifying CTEs more than once. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 29 Nov 2025 12:36:31 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4822774308217436905== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgcmV3cml0aW5nIGRhdGEtbW9kaWZ5aW5nIENURXMgbW9yZSB0aGFuIG9uY2UuCgpGb3Jt ZXJseSwgd2hlbiB1cGRhdGluZyBhbiBhdXRvLXVwZGF0YWJsZSB2aWV3LCBvciBhIHJlbGF0aW9u IHdpdGgKcnVsZXMsIGlmIHRoZSBvcmlnaW5hbCBxdWVyeSBoYWQgYW55IGRhdGEtbW9kaWZ5aW5n IENURXMsIHRoZSByZXdyaXRlcgp3b3VsZCByZXdyaXRlIHRob3NlIENURXMgbXVsdGlwbGUgdGlt ZXMgYXMgUmV3cml0ZVF1ZXJ5KCkgcmVjdXJzZWQKaW50byB0aGUgcHJvZHVjdCBxdWVyaWVzLiBJ biBtb3N0IGNhc2VzIHRoYXQgd2FzIGhhcm1sZXNzLCBiZWNhdXNlClJld3JpdGVRdWVyeSgpIGlz IG1vc3RseSBpZGVtcG90ZW50LiBIb3dldmVyLCBpZiB0aGUgQ1RFIGludm9sdmVkCnVwZGF0aW5n IGFuIGFsd2F5cy1nZW5lcmF0ZWQgY29sdW1uLCBpdCB3b3VsZCB0cmlnZ2VyIGFuIGVycm9yIGJl Y2F1c2UKYW55IHN1YnNlcXVlbnQgcmV3cml0ZSB3b3VsZCBhcHBlYXIgdG8gYmUgYXR0ZW1wdGlu ZyB0byBhc3NpZ24gYQpub24tZGVmYXVsdCB2YWx1ZSB0byB0aGUgYWx3YXlzLWdlbmVyYXRlZCBj b2x1bW4uCgpUaGlzIGNvdWxkIHBlcmhhcHMgYmUgZml4ZWQgYnkgYXR0ZW1wdGluZyB0byBtYWtl IFJld3JpdGVRdWVyeSgpIGZ1bGx5CmlkZW1wb3RlbnQsIGJ1dCB0aGF0IGxvb2tzIHF1aXRlIHRy aWNreSB0byBhY2hpZXZlLCBhbmQgd291bGQgcHJvYmFibHkKYmUgcXVpdGUgZnJhZ2lsZSwgZ2l2 ZW4gdGhhdCBtb3JlIGdlbmVyYXRlZC1jb2x1bW4tdHlwZSBmZWF0dXJlcyBtaWdodApiZSBhZGRl ZCBpbiB0aGUgZnV0dXJlLgoKSW5zdGVhZCwgZml4IGJ5IGFycmFuZ2luZyBmb3IgUmV3cml0ZVF1 ZXJ5KCkgdG8gcmV3cml0ZSBlYWNoIENURQpleGFjdGx5IG9uY2UgKGJ5IHRyYWNraW5nIHRoZSBu dW1iZXIgb2YgQ1RFcyBhbHJlYWR5IHJld3JpdHRlbiBhcyBpdApyZWN1cnNlcykuIFRoaXMgaGFz IHRoZSBhZHZhbnRhZ2Ugb2YgYmVpbmcgc2ltcGxlciBhbmQgbW9yZSBlZmZpY2llbnQsCmJ1dCBp dCBkb2VzIG1ha2UgUmV3cml0ZVF1ZXJ5KCkgZGVwZW5kZW50IG9uIHRoZSBvcmRlciBpbiB3aGlj aApyZXdyaXRlUnVsZUFjdGlvbigpIGpvaW5zIHRoZSBDVEUgbGlzdHMgZnJvbSB0aGUgb3JpZ2lu YWwgcXVlcnkgYW5kCnRoZSBydWxlIGFjdGlvbiwgc28gY2FyZSBtdXN0IGJlIHRha2VuIGlmIHRo YXQgaXMgZXZlciBjaGFuZ2VkLgoKUmVwb3J0ZWQtYnk6IEJlcm5pY2UgU291dGhleSA8YmVybmlj ZS5zb3V0aGV5QGdtYWlsLmNvbT4KQXV0aG9yOiBCZXJuaWNlIFNvdXRoZXkgPGJlcm5pY2Uuc291 dGhleUBnbWFpbC5jb20+CkF1dGhvcjogRGVhbiBSYXNoZWVkIDxkZWFuLmEucmFzaGVlZEBnbWFp bC5jb20+ClJldmlld2VkLWJ5OiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2Vk LWJ5OiBLaXJpbGwgUmVzaGtlIDxyZXNoa2VraXJpbGxAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tL0NBRURoNG55RDZNU0g5YlJPaHNPc3VUcUdBdl9RY2VVX0dEdk45 V2NITHRaVENZTTFrQUBtYWlsLmdtYWlsLmNvbQpCYWNrcGF0Y2gtdGhyb3VnaDogMTQKCkJyYW5j aAotLS0tLS0KUkVMXzE1X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMTM0YThlZTIyNDA1NTdlODE2NWNmZmU3MGQxOWU0ODkz N2NlY2UwMwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcmV3cml0 ZS9yZXdyaXRlSGFuZGxlci5jIHwgMzEgKysrKysrKysrKysrKysrKysrKysrKy0tLS0tCnNyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvd2l0aC5vdXQgICB8IDQxICsrKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC93aXRoLnNxbCAgICAgICAgfCAy MyArKysrKysrKysrKysrKysrKysrKwozIGZpbGVzIGNoYW5nZWQsIDkwIGluc2VydGlvbnMoKyks IDUgZGVsZXRpb25zKC0pCgo= --===============4822774308217436905==--