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 1u02Tv-00AS5c-Mf for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 18:06:31 +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 1u02Tt-00GweK-HA for pgsql-committers@arkaria.postgresql.org; Wed, 02 Apr 2025 18:06:29 +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 1u02Tt-00Gwe7-8I for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 18:06: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 1u02Tq-0030zw-11 for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 18:06: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 1u02Tn-00GmxQ-Se for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 18:06:23 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u02Tn-002Kp0-0Q for pgsql-committers@lists.postgresql.org; Wed, 02 Apr 2025 18:06:23 +0000 Content-Type: multipart/mixed; boundary="===============8564256457858998958==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Change SQL-language functions to use the plan cache. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 02 Apr 2025 18:06:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8564256457858998958== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q2hhbmdlIFNRTC1sYW5ndWFnZSBmdW5jdGlvbnMgdG8gdXNlIHRoZSBwbGFuIGNhY2hlLgoKSW4g dGhlIGhpc3RvcmljYWwgaW1wbGVtZW50YXRpb24gb2YgU1FMIGZ1bmN0aW9ucyAoaWYgdGhleSBk b24ndCBnZXQKaW5saW5lZCksIHdlIGJ1aWx0IHBsYW5zIGZvciBhbGwgdGhlIGNvbnRhaW5lZCBx dWVyaWVzIGF0IGZpcnN0IGNhbGwKd2l0aGluIGFuIG91dGVyIHF1ZXJ5LCBhbmQgdGhlbiByZS11 c2VkIHRob3NlIHBsYW5zIGZvciB0aGUgZHVyYXRpb24Kb2YgdGhlIG91dGVyIHF1ZXJ5LCBhbmQg dGhlbiBmb3Jnb3QgZXZlcnl0aGluZy4gIFRoaXMgd2FzIG5vdCBpZGVhbCwKbm90IGxlYXN0IGJl Y2F1c2UgdGhlIHBsYW5zIGNvdWxkIG5vdCBiZSBjdXN0b21pemVkIHRvIHNwZWNpZmljIHZhbHVl cwpvZiB0aGUgZnVuY3Rpb24ncyBwYXJhbWV0ZXJzLiAgT3VyIHBsYW5jYWNoZSBpbmZyYXN0cnVj dHVyZSBzZWVtcwptYXR1cmUgZW5vdWdoIHRvIGJlIHVzZWQgaGVyZS4gIFRoYXQgd2lsbCBzb2x2 ZSBib3RoIHRoZSBwcm9ibGVtIHdpdGgKbm90IGJlaW5nIGFibGUgdG8gYnVpbGQgY3VzdG9tIHBs YW5zIGFuZCB0aGUgcHJvYmxlbSB3aXRoIG5vdCBiZWluZwphYmxlIHRvIHNoYXJlIHdvcmsgYWNy b3NzIHN1Y2Nlc3NpdmUgb3V0ZXIgcXVlcmllcy4KCkFzaWRlIGZyb20gdGhvc2UgcGVyZm9ybWFu Y2UgY29uY2VybnMsIHRoaXMgY2hhbmdlIGZpeGVzIGEKbG9uZ3N0YW5kaW5nIGJ1Z2Fib28gd2l0 aCBTUUwgZnVuY3Rpb25zOiB5b3UgY291bGQgbm90IHdyaXRlIERETCB0aGF0CndvdWxkIGFmZmVj dCBsYXRlciBzdGF0ZW1lbnRzIGluIHRoZSBzYW1lIGZ1bmN0aW9uLiAgVGhhdCdzIG1vc3RseQpz dGlsbCB0cnVlIHdpdGggbmV3LXN0eWxlIFNRTCBmdW5jdGlvbnMsIHNpbmNlIHRoZSByZXN1bHRz IG9mIHBhcnNlCmFuYWx5c2lzIGFyZSBiYWtlZCBpbnRvIHRoZSBzdG9yZWQgcXVlcnkgdHJlZXMg KGFuZCBwcm90ZWN0ZWQgYnkKZGVwZW5kZW5jeSByZWNvcmRzKS4gIEJ1dCBmb3Igb2xkLXN0eWxl IFNRTCBmdW5jdGlvbnMsIGl0IHdpbGwgbm93CndvcmsgbXVjaCBhcyBpdCBkb2VzIHdpdGggUEwv cGdTUUwgZnVuY3Rpb25zLCBiZWNhdXNlIHdlIGRlbGF5IHBhcnNlCmFuYWx5c2lzIGFuZCBwbGFu bmluZyBvZiBlYWNoIHF1ZXJ5IHVudGlsIHdlJ3JlIHJlYWR5IHRvIHJ1biBpdC4KU29tZSBlZGdl IGNhc2VzIHRoYXQgcmVxdWlyZSByZXBsYW5uaW5nIGFyZSBub3cgaGFuZGxlZCBiZXR0ZXIgdG9v OwpzZWUgZm9yIGV4YW1wbGUgdGhlIG5ldyByb3dzZWN1cml0eSB0ZXN0LCB3aGVyZSB3ZSBub3cg ZGV0ZWN0IGFuIFJMUwpjb250ZXh0IGNoYW5nZSB0aGF0IHdhcyBwcmV2aW91c2x5IG1pc3NlZC4K Ck9uZSBvdGhlciBlZGdlLWNhc2UgY2hhbmdlIHRoYXQgbWlnaHQgYmUgd29ydGh5IG9mIGEgcmVs ZWFzZSBub3RlCmlzIHRoYXQgd2Ugbm93IGluc2lzdCB0aGF0IGEgU1FMIGZ1bmN0aW9uJ3MgcmVz dWx0IGJlIGdlbmVyYXRlZApieSB0aGUgcGh5c2ljYWxseS1sYXN0IHF1ZXJ5IHdpdGhpbiBpdC4g IFByZXZpb3VzbHksIGlmIHRoZSBsYXN0Cm9yaWdpbmFsIHF1ZXJ5IHdhcyBkZWxldGVkIGJ5IGEg RE8gSU5TVEVBRCBOT1RISU5HIHJ1bGUsIHdlJ2QgYmUKd2lsbGluZyB0byB0YWtlIHRoZSByZXN1 bHQgZnJvbSB0aGUgcHJlY2VkaW5nIHF1ZXJ5IGluc3RlYWQuClRoaXMgYmVoYXZpb3Igd2FzIHVu ZG9jdW1lbnRlZCBleGNlcHQgaW4gc291cmNlLWNvZGUgY29tbWVudHMsCmFuZCBpdCBzZWVtcyBo YXJkIHRvIGJlbGlldmUgdGhhdCBhbnlvbmUncyByZWx5aW5nIG9uIGl0LgoKQWxvbmcgdGhlIHdh eSB0byB0aGlzIGZlYXR1cmUsIHdlIG5lZWRlZCBhIGZldyBpbmZyYXN0cnVjdHVyZSBjaGFuZ2Vz OgoKKiBUaGUgcGxhbmNhY2hlIGNhbiBub3cgdGFrZSBlaXRoZXIgYSByYXcgcGFyc2UgdHJlZSBv ciBhbgphbmFseXplZC1idXQtbm90LXJld3JpdHRlbiBRdWVyeSBhcyB0aGUgc3RhcnRpbmcgcG9p bnQgZm9yIGEKQ2FjaGVkUGxhblNvdXJjZS4gIElmIGdpdmVuIGEgUXVlcnksIGl0IGlzIGNhbGxl cidzIHJlc3BvbnNpYmlsaXR5CnRoYXQgbm90aGluZyB3aWxsIGhhcHBlbiB0byBpbnZhbGlkYXRl IHRoYXQgZm9ybSBvZiB0aGUgcXVlcnkuCldlIHVzZSB0aGlzIGZvciBuZXctc3R5bGUgU1FMIGZ1 bmN0aW9ucywgd2hlcmUgd2hhdCdzIGluIHBnX3Byb2MgaXMKc2VyaWFsaXplZCBRdWVyeShzKSBh bmQgd2UgdHJ1c3QgdGhlIGRlcGVuZGVuY3kgbWVjaGFuaXNtIHRvIGRpc2FsbG93CkRETCB0aGF0 IHdvdWxkIGJyZWFrIHRob3NlLgoKKiBUaGUgcGxhbmNhY2hlIG5vdyBvZmZlcnMgYSB3YXkgdG8g aW52b2tlIGEgcG9zdC1yZXdyaXRlIGNhbGxiYWNrCnRvIGV4YW1pbmUvbW9kaWZ5IHRoZSByZXdy aXR0ZW4gcGFyc2UgdHJlZSB3aGVuIGl0IGlzIHJlYnVpbGRpbmcKdGhlIHBhcnNlIHRyZWVzIGFm dGVyIGEgY2FjaGUgaW52YWxpZGF0aW9uLiAgV2UgbmVlZCB0aGlzIGJlY2F1c2UKU1FMIGZ1bmN0 aW9ucyBzb21ldGltZXMgYWRqdXN0IHRoZSBwYXJzZSB0cmVlIHRvIG1ha2UgaXRzIG91dHB1dApl eGFjdGx5IG1hdGNoIHRoZSBkZWNsYXJlZCByZXN1bHQgdHlwZTsgaWYgdGhlIHBsYW4gZ2V0cyBy ZWJ1aWx0LAp0aGF0IGhhcyB0byBiZSByZS1kb25lLgoKKiBUaGVyZSBpcyBhIG5ldyBiYWNrZW5k IG1vZHVsZSB1dGlscy9jYWNoZS9mdW5jY2FjaGUuYyB0aGF0CmFic3RyYWN0cyB0aGUgaWRlYSBv ZiBjYWNoaW5nIGRhdGEgYWJvdXQgYSBzcGVjaWZpYyBmdW5jdGlvbgp1c2FnZSAoYSBwYXJ0aWN1 bGFyIGZ1bmN0aW9uIGFuZCBzZXQgb2YgaW5wdXQgZGF0YSB0eXBlcykuClRoZSBjb2RlIGluIGl0 IGlzIG1vdmVkIGFsbW9zdCB2ZXJiYXRpbSBmcm9tIFBML3BnU1FMLCB3aGljaApoYXMgZG9uZSB0 aGF0IGZvciBhIGxvbmcgdGltZS4gIFdlIHVzZSB0aGF0IGxvZ2ljIG5vdyBmb3IKU1FMLWxhbmd1 YWdlIGZ1bmN0aW9ucyB0b28sIGFuZCBtYXliZSBvdGhlciBQTHMgd2lsbCBoYXZlIHVzZQpmb3Ig aXQgaW4gdGhlIGZ1dHVyZS4KCkF1dGhvcjogQWxleGFuZGVyIFB5aGFsb3YgPGEucHloYWxvdkBw b3N0Z3Jlc3Byby5ydT4KQ28tYXV0aG9yZWQtYnk6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51 cz4KUmV2aWV3ZWQtYnk6IFBhdmVsIFN0ZWh1bGUgPHBhdmVsLnN0ZWh1bGVAZ21haWwuY29tPgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzgyMTY2MzkuTnlpVVVTdUE5Z0BhaXZlbmxh cHRvcAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzBkY2E1ZDY4ZDdiZWJmMmMxMDM2ZmQ4NDg3NTUz M2FmZWY2ZGY5OTIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC94 ZnVuYy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAxNSAtCnNyYy9iYWNrZW5k L2NhdGFsb2cvcGdfcHJvYy5jICAgICAgICAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvYmFj a2VuZC9leGVjdXRvci9mdW5jdGlvbnMuYyAgICAgICAgICAgICAgICAgICB8IDEzOTEgKysrKysr KysrKysrKy0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAg ICAgICAgICAgfCAgICA0ICstCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMgICAgICAgICAg ICAgICAgICAgICAgIHwgICAzOSArCnNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL01ha2VmaWxlICAg ICAgICAgICAgICAgICAgIHwgICAgMSArCnNyYy9iYWNrZW5kL3V0aWxzL2NhY2hlL2Z1bmNjYWNo ZS5jICAgICAgICAgICAgICAgIHwgIDYxMiArKysrKysrKysKc3JjL2JhY2tlbmQvdXRpbHMvY2Fj aGUvbWVzb24uYnVpbGQgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2JhY2tlbmQvdXRpbHMv Y2FjaGUvcGxhbmNhY2hlLmMgICAgICAgICAgICAgICAgfCAgMTkxICsrLQpzcmMvaW5jbHVkZS9l eGVjdXRvci9mdW5jdGlvbnMuaCAgICAgICAgICAgICAgICAgICB8ICAgIDMgKy0Kc3JjL2luY2x1 ZGUvcGFyc2VyL2FuYWx5emUuaCAgICAgICAgICAgICAgICAgICAgICAgfCAgICAxICsKc3JjL2lu Y2x1ZGUvdXRpbHMvZnVuY2NhY2hlLmggICAgICAgICAgICAgICAgICAgICAgfCAgMTM0ICsrCnNy Yy9pbmNsdWRlL3V0aWxzL3BsYW5jYWNoZS5oICAgICAgICAgICAgICAgICAgICAgIHwgICAzMSAr LQpzcmMvcGwvcGxwZ3NxbC9zcmMvcGxfY29tcC5jICAgICAgICAgICAgICAgICAgICAgICB8ICA0 MjkgKy0tLS0tCnNyYy9wbC9wbHBnc3FsL3NyYy9wbF9mdW5jcy5jICAgICAgICAgICAgICAgICAg ICAgIHwgICAgOSArLQpzcmMvcGwvcGxwZ3NxbC9zcmMvcGxfaGFuZGxlci5jICAgICAgICAgICAg ICAgICAgICB8ICAgMTUgKy0Kc3JjL3BsL3BscGdzcWwvc3JjL3BscGdzcWwuaCAgICAgICAgICAg ICAgICAgICAgICAgfCAgIDQ1ICstCi4uLi90ZXN0X2V4dGVuc2lvbnMvZXhwZWN0ZWQvdGVzdF9l eHRlbnNpb25zLm91dCAgIHwgICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0 ZV9mdW5jdGlvbl9zcWwub3V0ICB8ICAgNTcgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9y YW5nZWZ1bmNzLm91dCAgICAgICAgICAgfCAgICAyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvcm93c2VjdXJpdHkub3V0ICAgICAgICAgIHwgICA1MSArCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2NyZWF0ZV9mdW5jdGlvbl9zcWwuc3FsICAgICAgIHwgICAzNCArCnNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL3Jvd3NlY3VyaXR5LnNxbCAgICAgICAgICAgICAgIHwgICA0NCArCnNyYy90b29scy9wZ2lu ZGVudC90eXBlZGVmcy5saXN0ICAgICAgICAgICAgICAgICAgIHwgICAgOCArCjI0IGZpbGVzIGNo YW5nZWQsIDIxMzIgaW5zZXJ0aW9ucygrKSwgOTg5IGRlbGV0aW9ucygtKQoK --===============8564256457858998958==--