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 1uUL6J-001foU-A9 for pgsql-committers@arkaria.postgresql.org; Wed, 25 Jun 2025 08:03:23 +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 1uUL5J-001CZo-7t for pgsql-committers@arkaria.postgresql.org; Wed, 25 Jun 2025 08:02:21 +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.94.2) (envelope-from ) id 1uUL5J-001CZS-0q for pgsql-committers@lists.postgresql.org; Wed, 25 Jun 2025 08:02:21 +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 1uUL5H-003sOf-2F for pgsql-committers@lists.postgresql.org; Wed, 25 Jun 2025 08:02:20 +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 1uUL5H-00AxwD-2s for pgsql-committers@lists.postgresql.org; Wed, 25 Jun 2025 08:02:19 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uUL5G-003Fl7-1P for pgsql-committers@lists.postgresql.org; Wed, 25 Jun 2025 08:02:18 +0000 Content-Type: multipart/mixed; boundary="===============3260357830652343029==" MIME-Version: 1.0 From: Peter Eisentraut To: pgsql-committers@lists.postgresql.org Subject: pgsql: Restrict virtual columns to use built-in functions and types X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 25 Jun 2025 08:02:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3260357830652343029== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVzdHJpY3QgdmlydHVhbCBjb2x1bW5zIHRvIHVzZSBidWlsdC1pbiBmdW5jdGlvbnMgYW5kIHR5 cGVzCgpKdXN0IGxpa2Ugc2VsZWN0aW5nIGZyb20gYSB2aWV3IGlzIGV4cGxvaXRhYmxlIChDVkUt MjAyNC03MzQ4KSwKc2VsZWN0aW5nIGZyb20gYSB0YWJsZSB3aXRoIHZpcnR1YWwgZ2VuZXJhdGVk IGNvbHVtbnMgaXMgZXhwbG9pdGFibGUuClVzZXJzIHdobyBhcmUgY29uY2VybmVkIGFib3V0IHRo aXMgY2FuIGF2b2lkIHNlbGVjdGluZyBmcm9tIHZpZXdzLCBidXQKdGVsbGluZyB0aGVtIHRvIGF2 b2lkIHNlbGVjdGluZyBmcm9tIHRhYmxlcyBpcyBsZXNzIHByYWN0aWNhbC4KClRvIGFkZHJlc3Mg dGhpcywgdGhpcyBjaGFuZ2VzIGl0IHNvIHRoYXQgZ2VuZXJhdGlvbiBleHByZXNzaW9ucyBmb3IK dmlydHVhbCBnZW5lcmF0ZWQgY29sdW1ucyBhcmUgcmVzdHJpY3RlZCB0byB1c2luZyBidWlsdC1p biBmdW5jdGlvbnMKYW5kIHR5cGVzLCBhbmQgdGhlIGNvbHVtbnMgYXJlIHJlc3RyaWN0ZWQgdG8g aGF2aW5nIGEgYnVpbHQtaW4gdHlwZS4KV2UgYXNzdW1lIHRoYXQgYnVpbHQtaW4gZnVuY3Rpb25z IGFuZCB0eXBlcyBjYW5ub3QgYmUgZXhwbG9pdGVkIGZvcgp0aGlzIHB1cnBvc2UuCgpJbiB0aGUg ZnV0dXJlLCB0aGlzIGNvdWxkIGJlIGV4cGFuZGVkIGJ5IHNvbWUgbmV3IG1lY2hhbmlzbSB0byBk ZWNsYXJlCm90aGVyIGZ1bmN0aW9ucyBhbmQgdHlwZXMgYXMgc2FmZSBvciB0cnVzdGVkIGZvciB0 aGlzIHB1cnBvc2UsIGJ1dAp0aGF0IGlzIHRvIGJlIGRlc2lnbmVkLgoKKEFuIGFsdGVybmF0aXZl IGFwcHJvYWNoIG1pZ2h0IGhhdmUgYmVlbiB0byBleHBhbmQgdGhlCnJlc3RyaWN0X25vbnN5c3Rl bV9yZWxhdGlvbl9raW5kIEdVQyB0byBoYW5kbGUgdGhpcywgbGlrZSB0aGUgZml4IGZvcgpDVkUt MjAyNC03MzQ4LiAgQnV0IHRoYXQgaXMga2luZCBvZiBhbiB1Z2x5IGFwcHJvYWNoLiAgVGhhdCBm aXggaGFkIHRvCmZpdCBpbiB0aGUgY29uc3RyYWludHMgb2YgZml4aW5nIGFuIGFuY2llbnQgdnVs bmVyYWJpbGl0eSBpbiBhbGwKYnJhbmNoZXMuICBTaW5jZSB2aXJ0dWFsIGdlbmVyYXRlZCBjb2x1 bW5zIGFyZSBuZXcsIHdlJ3JlIGZyZWUgZnJvbQp0aGUgY29uc3RyYWludHMgb2YgdGhlIHBhc3Qs IGFuZCB3ZSBjYW4gYW5kIHNob3VsZCB1c2UgY2xlYW5lcgpvcHRpb25zLikKClJlcG9ydGVkLWJ5 OiBGZWlrZSBTdGVlbmJlcmdlbiA8ZmVpa2VzdGVlbmJlcmdlbkBnbWFpbC5jb20+ClJldmlld2Vk LWJ5OiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0 dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL21lc3NhZ2UtaWQvZmxhdC9DQUtfcy1HMlE3ZGU4UTBx T1lVUiUzRF9DVEI1Rnp6VkJtNWlaak9wJTJCbWVWV3BNcG1mTzB3JTQwbWFpbC5nbWFpbC5jb20K CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8wY2Q2OWIzZDdlZjM1N2YyYjQzMjU4ZGU1ODMxYzRkZTBi ZDUxZGVjCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwvZGRsLnNn bWwgICAgICAgICAgICAgICAgICAgICAgICAgICB8IDEwICsrKwpkb2Mvc3JjL3NnbWwvcmVmL2Ny ZWF0ZV90YWJsZS5zZ21sICAgICAgICAgICAgICB8ICA5ICsrKwpzcmMvYmFja2VuZC9jYXRhbG9n L2hlYXAuYyAgICAgICAgICAgICAgICAgICAgICB8IDkzICsrKysrKysrKysrKysrKysrKysrKysr KysKc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICAgfCAgMiAr LQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF92aXJ0dWFsLm91dCB8IDQzICsr KysrKy0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3B1YmxpY2F0aW9uLm91dCAgICAg ICB8IDEyICsrKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJhdGVkX3ZpcnR1YWwuc3FsICAg ICAgfCAyNCArKysrLS0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3B1YmxpY2F0aW9uLnNxbCAgICAg ICAgICAgIHwgIDUgKy0KOCBmaWxlcyBjaGFuZ2VkLCAxNjMgaW5zZXJ0aW9ucygrKSwgMzUgZGVs ZXRpb25zKC0pCgo= --===============3260357830652343029==--