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 1wuX7o-000ldh-17 for pgsql-committers@arkaria.postgresql.org; Thu, 13 Aug 2026 15:13:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wuX7k-00E4aK-2s for pgsql-committers@arkaria.postgresql.org; Thu, 13 Aug 2026 15:13:42 +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 1wtQGF-00HQvi-2E for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:51 +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.98.2) (envelope-from ) id 1wtQFq-00000001C04-2949 for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:50 +0000 Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wtQFn-00217h-32 for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:23 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1wtQFn-00000000y5S-0JEd for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:23 +0000 Content-Type: multipart/mixed; boundary="===============0449515852892261019==" MIME-Version: 1.0 From: Noah Misch To: pgsql-committers@lists.postgresql.org Subject: pgsql: Check for USAGE privilege on types used by stored expressions. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 10 Aug 2026 13:41:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0449515852892261019== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q2hlY2sgZm9yIFVTQUdFIHByaXZpbGVnZSBvbiB0eXBlcyB1c2VkIGJ5IHN0b3JlZCBleHByZXNz aW9ucy4KClRoaXMgb21pc3Npb24gYWxsb3dlZCByb2xlcyB3aXRob3V0IFVTQUdFIG9uIGEgdHlw ZSB0byBjcmVhdGUKc3RvcmVkIGV4cHJlc3Npb25zIHRoYXQgZGVwZW5kIG9uIGl0LCB3aGljaCBj b3VsZCBwcmV2ZW50IHRoZSBvd25lcgpmcm9tIGNoYW5naW5nIHRoZSB0eXBlIGxhdGVyLgoKVGhl IGNoZWNrcyBkZWxpYmVyYXRlbHkgbGl2ZSBpbiB0aGUgY29tbWFuZCBwYXRocyByYXRoZXIgdGhh biB0aGUKZGVwZW5kZW5jeS1yZWNvcmRpbmcgcm91dGluZXMuICBUaG9zZSByb3V0aW5lcyBhbHNv IHJ1biB3aGVuZXZlcgp0aGUgc2VydmVyIHJlLWRlcml2ZXMgYW4gZXhpc3RpbmcgZXhwcmVzc2lv biwgYW5kIHJlLWNoZWNraW5nIHRoZXJlCndvdWxkIGJyZWFrIHJvdXRpbmUgbWFpbnRlbmFuY2Ug Zm9yIGFuIG93bmVyIHdobyBoYXMgc2luY2UgbG9zdApVU0FHRSBvbiBhIHR5cGUgaXRzIG9iamVj dHMgYWxyZWFkeSByZWZlcmVuY2UuICAoQ2hlY2tpbmcgaW4gdGhlCmRlcGVuZGVuY3ktcmVjb3Jk aW5nIHJvdXRpbmVzIHdvdWxkIGFsc28gcmVxdWlyZSBhZGRpdGlvbmFsCkNvbW1hbmRDb3VudGVy SW5jcmVtZW50KCkgY2FsbHMgdG8gYXZvaWQgc3B1cmlvdXMgZXJyb3JzLikKClRoZSBhZGRpdGlv biBvZiBhIHBhcmFtZXRlciB0byBBbHRlckRvbWFpbkFkZENvbnN0cmFpbnQoKSBicmVha3MKQUJJ IGNvbXBhdGliaWxpdHksIGJ1dCB3ZSBhcmUgdW5hd2FyZSBvZiBhbnkgaW1wYWN0ZWQgdGhpcmQt cGFydHkKY29kZS4KClJlcG9ydGVkLWJ5OiBOb2FoIE1pc2NoIDxub2FoQGxlYWRib2F0LmNvbT4K QXV0aG9yOiBOYXRoYW4gQm9zc2FydCA8bmF0aGFuZGJvc3NhcnRAZ21haWwuY29tPgpSZXZpZXdl ZC1ieTogTm9haCBNaXNjaCA8bm9haEBsZWFkYm9hdC5jb20+ClJldmlld2VkLWJ5OiBUb20gTGFu ZSA8dGdsQHNzcy5wZ2gucGEudXM+ClJldmlld2VkLWJ5OiBSb2JlcnQgSGFhcyA8cm9iZXJ0bWhh YXNAZ21haWwuY29tPgpTZWN1cml0eTogQ1ZFLTIwMjYtNjQ3MApCYWNrcGF0Y2gtdGhyb3VnaDog MTQKCkJyYW5jaAotLS0tLS0KUkVMXzE5X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNDI0ZmI3MTYwYmM1MWQ1NWM0YmUyMDIz ZDkyMzhmMmRiODgwN2IzNQpBdXRob3I6IE5hdGhhbiBCb3NzYXJ0IDxuYXRoYW5AcG9zdGdyZXNx bC5vcmc+CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9n L2RlcGVuZGVuY3kuYyAgICAgICAgIHwgNzYgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysKc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICB8IDIyICsrKysrKysr KwpzcmMvYmFja2VuZC9jYXRhbG9nL2luZGV4LmMgICAgICAgICAgICAgIHwgIDMgKysKc3JjL2Jh Y2tlbmQvY2F0YWxvZy9wZ19hdHRyZGVmLmMgICAgICAgICB8ICAzICsrCnNyYy9iYWNrZW5kL2Nh dGFsb2cvcGdfY29uc3RyYWludC5jICAgICAgfCAgMyArKwpzcmMvYmFja2VuZC9jYXRhbG9nL3Bn X3Byb2MuYyAgICAgICAgICAgIHwgIDYgKysrCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfcHVibGlj YXRpb24uYyAgICAgfCAgNCArKwpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3R5cGUuYyAgICAgICAg ICAgIHwgIDYgKysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5jICAgICAgICAgfCAx NiArKysrKysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3BvbGljeS5jICAgICAgICAgICAgfCAgOCAr KysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3Byb3BncmFwaGNtZHMuYyAgICAgfCAgNyArKysKc3Jj L2JhY2tlbmQvY29tbWFuZHMvc3RhdHNjbWRzLmMgICAgICAgICB8ICA1ICsrKwpzcmMvYmFja2Vu ZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgIHwgMTkgKysrKysrKy0Kc3JjL2JhY2tlbmQv Y29tbWFuZHMvdHJpZ2dlci5jICAgICAgICAgICB8ICA1ICsrKwpzcmMvYmFja2VuZC9jb21tYW5k cy90eXBlY21kcy5jICAgICAgICAgIHwgMzMgKysrKysrKysrKystLS0Kc3JjL2JhY2tlbmQvcGFy c2VyL3BhcnNlX3V0aWxjbWQuYyAgICAgICB8IDEwICsrKysrCnNyYy9iYWNrZW5kL3Jld3JpdGUv cmV3cml0ZURlZmluZS5jICAgICAgfCAgMiArCnNyYy9iYWNrZW5kL3Rjb3AvdXRpbGl0eS5jICAg ICAgICAgICAgICAgfCAgMyArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2RlcGVuZGVuY3kuaCAgICAg ICAgIHwgIDQgKysKc3JjL2luY2x1ZGUvY29tbWFuZHMvdHlwZWNtZHMuaCAgICAgICAgICB8ICAz ICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHJpdmlsZWdlcy5vdXQgfCA0NiArKysrKysr KysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ByaXZpbGVnZXMuc3FsICAgICAgfCA0 MyArKysrKysrKysrKysrKysrKysKMjIgZmlsZXMgY2hhbmdlZCwgMzE4IGluc2VydGlvbnMoKyks IDkgZGVsZXRpb25zKC0pCgo= --===============0449515852892261019==--