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 1vyHPl-00HaTS-0i for pgsql-committers@arkaria.postgresql.org; Thu, 05 Mar 2026 22:43:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyHPj-001n0J-1t for pgsql-committers@arkaria.postgresql.org; Thu, 05 Mar 2026 22:43:28 +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 1vyHPi-001moP-2W for pgsql-committers@lists.postgresql.org; Thu, 05 Mar 2026 22:43:27 +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 1vyHPg-000000015Ly-34Xp for pgsql-committers@lists.postgresql.org; Thu, 05 Mar 2026 22:43: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.96) (envelope-from ) id 1vyHPe-001CLJ-1N for pgsql-committers@lists.postgresql.org; Thu, 05 Mar 2026 22:43:22 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyHPe-002a3L-1n for pgsql-committers@lists.postgresql.org; Thu, 05 Mar 2026 22:43:22 +0000 Content-Type: multipart/mixed; boundary="===============3257011103925639593==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Simplify creation of built-in functions with non-default ACLs. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 05 Mar 2026 22:43:22 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3257011103925639593== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2ltcGxpZnkgY3JlYXRpb24gb2YgYnVpbHQtaW4gZnVuY3Rpb25zIHdpdGggbm9uLWRlZmF1bHQg QUNMcy4KClVwIHRvIG5vdywgdG8gY3JlYXRlIHN1Y2ggYSBmdW5jdGlvbiwgb25lIGhhZCB0byBt YWtlIGEgcGdfcHJvYy5kYXQKZW50cnkgYW5kIHRoZW4gbW9kaWZ5IGl0IHdpdGggR1JBTlQvUkVW T0tFIGNvbW1hbmRzLCB3aGljaCB3ZSBwdXQgaW4Kc3lzdGVtX2Z1bmN0aW9ucy5zcWwuICBUaGF0 IHNlZW1zIGEgbGl0dGxlIHVnbHkgdGhvdWdoLCBiZWNhdXNlIGl0CnZpb2xhdGVzIHRoZSBpZGVh IG9mIGhhdmluZyBhIHNpbmdsZSBzb3VyY2Ugb2YgdHJ1dGggYWJvdXQgdGhlIGluaXRpYWwKY29u dGVudHMgb2YgcGdfcHJvYywgYW5kIGl0IHJlc3VsdHMgaW4gbGVhdmluZyBkZWFkIHJvd3MgaW4g dGhlCmluaXRpYWwgY29udGVudHMgb2YgcGdfcHJvYy4KClRoaXMgcGF0Y2ggaW1wcm92ZXMgbWF0 dGVycyBieSBhbGxvd2luZyBhY2xpdGVtaW4gdG8gd29yayBkdXJpbmcgZWFybHkKYm9vdHN0cmFw LCBiZWZvcmUgcGdfYXV0aGlkIGhhcyBiZWVuIGxvYWRlZC4gIE9uIHRoZSBzYW1lIHByaW5jaXBs ZQp0aGF0IHdlIHVzZSBmb3IgZWFybHkgYWNjZXNzIHRvIHBnX3R5cGUgZGV0YWlscywgcHV0IGEg dGFibGUgb2Yga25vd24KYnVpbHQtaW4gcm9sZSBuYW1lcyBpbnRvIGJvb3RzdHJhcC5jLCBhbmQg dXNlIHRoYXQgaW4gYm9vdHN0cmFwIG1vZGUuCgpUbyBjcmVhdGUgYSBidWlsdC1pbiBmdW5jdGlv biB3aXRoIGEgbm9uLWRlZmF1bHQgQUNMLCBvbmUgc2hvdWxkIHdyaXRlCnRoZSBkZXNpcmVkIEFD TCBsaXN0IGluIGl0cyBwZ19wcm9jLmRhdCBlbnRyeSwgdXNpbmcgYSBzaW1wbGlmaWVkCnZlcnNp b24gb2YgYWNsaXRlbW91dCdzIG5vdGF0aW9uOiBvbWl0IHRoZSBncmFudG9yIChpZiBpdCBpcyB0 aGUKYm9vdHN0cmFwIHN1cGVydXNlciwgd2hpY2ggaXQgcHJldHR5IG11Y2ggYWx3YXlzIHNob3Vs ZCBiZSkgYW5kIHNwZWxsCnRoZSBib290c3RyYXAgc3VwZXJ1c2VyJ3MgbmFtZSBhcyBQT1NUR1JF Uywgc2ltaWxhcmx5IHRvIHRoZSBub3RhdGlvbgp1c2VkIGVsc2V3aGVyZSBpbiBzcmMvaW5jbHVk ZS9jYXRhbG9nLiAgVGhpcyByZXN1bHRzIGluIGVudHJpZXMgbGlrZQoKICBwcm9hY2wgPT4gJ3tQ T1NUR1JFUz1YLHBnX21vbml0b3I9WH0nCgp3aGljaCBzaG93cyB0aGF0IHdlJ3ZlIHJldm9rZWQg cHVibGljIGV4ZWN1dGUgcGVybWlzc2lvbnMgYW5kIGluc3RlYWQKZ3JhbnRlZCB0aGF0IHRvIHBn X21vbml0b3IuCgpJbiBhZGRpdGlvbiB0byBmaXhpbmcgdXAgcGdfcHJvYy5kYXQgZW50cmllcywg SSBnb3QgcmlkIG9mIHNvbWUKcm9sZSBncmFudHMgdGhhdCBoYWQgYmVlbiBzdHVjayBpbnRvIHN5 c3RlbV9mdW5jdGlvbnMuc3FsLAphbmQgaW5zdGVhZCBwdXQgdGhlbSBpbnRvIGEgbmV3IGZpbGUg cGdfYXV0aF9tZW1iZXJzLmRhdDsKdGhhdCBzZWVtcyBsaWtlIGEgZmFyIGxlc3MgcmFuZG9tIHBs YWNlIHRvIHB1dCB0aGUgaW5mb3JtYXRpb24uCgpUaGUgY29ycmVjdG5lc3Mgb2YgdGhlIGRhdGEg Y2hhbmdlcyBjYW4gYmUgdmVyaWZpZWQgYnkgY29tcGFyaW5nIHRoZQppbml0aWFsIGNvbnRlbnRz IG9mIHBnX3Byb2MgYW5kIHBnX2F1dGhfbWVtYmVycyBiZWZvcmUgYW5kIGFmdGVyLgpwZ19wcm9j IHNob3VsZCBtYXRjaCBleGFjdGx5LCBidXQgdGhlIE9JRCBjb2x1bW4gb2YgcGdfYXV0aF9tZW1i ZXJzCndpbGwgcHJvYmFibHkgYmUgZGlmZmVyZW50IGJlY2F1c2UgdGhvc2UgT0lEcyBub3cgZ2V0 IGFzc2lnbmVkIGEKbGl0dGxlIGVhcmxpZXIgaW4gYm9vdHN0cmFwLiAgKEkgZm9yY2VkIGEgY2F0 dmVyc2lvbiBidW1wIG91dCBvZgpjYXV0aW9uLCBidXQgaXQgd2Fzbid0IHJlYWxseSBuZWNlc3Nh cnkuKQoKQXV0aG9yOiBUb20gTGFuZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2VkLWJ5OiDD gWx2YXJvIEhlcnJlcmEgPGFsdmhlcnJlQGt1cmlsZW11LmRlPgpEaXNjdXNzaW9uOiBodHRwczov L3Bvc3Rnci5lcy9tLzE4MzI5MmJiLTQ4OTEtNGM5Ni1hM2NhLWU3OGI1ZTBlMTM1OEBkdW5zbGFu ZS5uZXQKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mOTVkNzNlZDQzMzIwN2M0MzIzODAyZGM5NmU1 MmYzZTU1NTNhODZjCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9i b290c3RyYXAvYm9vdHN0cmFwLmMgICAgICAgIHwgIDU5ICsrKysrKysrKwpzcmMvYmFja2VuZC9j YXRhbG9nL3N5c3RlbV9mdW5jdGlvbnMuc3FsIHwgMTY2ICstLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsICAgICB8ICAxOSArLS0Kc3Jj L2JhY2tlbmQvdXRpbHMvYWR0L2FjbC5jICAgICAgICAgICAgICB8ICAyNiArKy0tCnNyYy9pbmNs dWRlL2Jvb3RzdHJhcC9ib290c3RyYXAuaCAgICAgICAgfCAgIDIgKwpzcmMvaW5jbHVkZS9jYXRh bG9nL01ha2VmaWxlICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2 ZXJzaW9uLmggICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL21lc29uLmJ1aWxk ICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19hdXRoX21lbWJlcnMuZGF0 ICB8ICAyMCArKysKc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19hdXRoX21lbWJlcnMuaCAgICB8ICAy NyArKystLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX2F1dGhpZC5kYXQgICAgICAgIHwgICA2ICst CnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQgICAgICAgICAgfCAyMDEgKysrKysrKysr KysrKysrKysrKystLS0tLS0tLS0tLQoxMiBmaWxlcyBjaGFuZ2VkLCAyNjggaW5zZXJ0aW9ucygr KSwgMjYyIGRlbGV0aW9ucygtKQoK --===============3257011103925639593==--