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 1wuXAB-000lpG-2R for pgsql-committers@arkaria.postgresql.org; Thu, 13 Aug 2026 15:16:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wuXA8-00EGxg-2l for pgsql-committers@arkaria.postgresql.org; Thu, 13 Aug 2026 15:16:09 +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 1wtQGO-00HR1H-10 for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:59 +0000 Received: from mahout.postgresql.org ([72.32.157.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 1wtQFs-00000001C0W-3ljE for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:58 +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 1wtQFq-00217L-2f for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:26 +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 1wtQFp-00000000yA0-2cln for pgsql-committers@lists.postgresql.org; Mon, 10 Aug 2026 13:41:25 +0000 Content-Type: multipart/mixed; boundary="===============7788501680888284548==" 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:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7788501680888284548== 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 MTQKCkJyYW5jaAotLS0tLS0KUkVMXzE4X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8v Z2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMjc4MDUzODQzM2ZjM2I0MGI0ZTFlN2Jj N2NiZDM1MGUzN2I2ZDU1MApBdXRob3I6IE5hdGhhbiBCb3NzYXJ0IDxuYXRoYW5AcG9zdGdyZXNx bC5vcmc+CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jYXRhbG9n L2RlcGVuZGVuY3kuYyAgICAgICAgIHwgODEgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr KysKc3JjL2JhY2tlbmQvY2F0YWxvZy9oZWFwLmMgICAgICAgICAgICAgICB8IDIyICsrKysrKysr KwpzcmMvYmFja2VuZC9jYXRhbG9nL2luZGV4LmMgICAgICAgICAgICAgIHwgIDMgKysKc3JjL2Jh Y2tlbmQvY2F0YWxvZy9wZ19hdHRyZGVmLmMgICAgICAgICB8ICAzICsrCnNyYy9iYWNrZW5kL2Nh dGFsb2cvcGdfY29uc3RyYWludC5jICAgICAgfCAgMyArKwpzcmMvYmFja2VuZC9jYXRhbG9nL3Bn X3Byb2MuYyAgICAgICAgICAgIHwgIDYgKysrCnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfcHVibGlj YXRpb24uYyAgICAgfCAgNCArKwpzcmMvYmFja2VuZC9jYXRhbG9nL3BnX3R5cGUuYyAgICAgICAg ICAgIHwgIDYgKysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2luZGV4Y21kcy5jICAgICAgICAgfCAx NiArKysrKysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3BvbGljeS5jICAgICAgICAgICAgfCAgOCAr KysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3N0YXRzY21kcy5jICAgICAgICAgfCAgNSArKwpzcmMv YmFja2VuZC9jb21tYW5kcy90YWJsZWNtZHMuYyAgICAgICAgIHwgMTkgKysrKysrKy0Kc3JjL2Jh Y2tlbmQvY29tbWFuZHMvdHJpZ2dlci5jICAgICAgICAgICB8ICA1ICsrCnNyYy9iYWNrZW5kL2Nv bW1hbmRzL3R5cGVjbWRzLmMgICAgICAgICAgfCAzMyArKysrKysrKysrKy0tCnNyYy9iYWNrZW5k L3BhcnNlci9wYXJzZV91dGlsY21kLmMgICAgICAgfCAxMCArKysrCnNyYy9iYWNrZW5kL3Jld3Jp dGUvcmV3cml0ZURlZmluZS5jICAgICAgfCAgMiArCnNyYy9iYWNrZW5kL3Rjb3AvdXRpbGl0eS5j ICAgICAgICAgICAgICAgfCAgMyArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2RlcGVuZGVuY3kuaCAg ICAgICAgIHwgIDQgKysKc3JjL2luY2x1ZGUvY29tbWFuZHMvdHlwZWNtZHMuaCAgICAgICAgICB8 ICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcHJpdmlsZWdlcy5vdXQgfCA0NiArKysr KysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvcHJpdmlsZWdlcy5zcWwgICAgICB8 IDQzICsrKysrKysrKysrKysrKysrCjIxIGZpbGVzIGNoYW5nZWQsIDMxNiBpbnNlcnRpb25zKCsp LCA5IGRlbGV0aW9ucygtKQoK --===============7788501680888284548==--