BUG #18251: Incorrect DROP VIEW pg_catalog.* behavior
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #18251: Incorrect DROP VIEW pg_catalog.* behavior |
| Дата | |
| Msg-id | 18251-1f41c42bb11eace0@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #18251: Incorrect DROP VIEW pg_catalog.* behavior
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18251 Logged by: Vardan Pogosyan Email address: vardan.pogosyn@yandex.ru PostgreSQL version: 15.5 Operating system: Ubuntu 22.04 Description: Hello! When i try to drop and create system view, i get following behavior: postgres=# DROP VIEW pg_catalog.pg_config; DROP VIEW postgres=# CREATE OR REPLACE VIEW pg_catalog.pg_config AS SELECT pg_config.name, pg_config.setting FROM pg_config() pg_config(name, setting); ERROR: permission denied to create "pg_catalog.pg_config" DETAIL: System catalog modifications are currently disallowed. I'm not sure, but it's look strange. When i connect to template1, i can use droped views. But if drop view on template1 problem repeats. I find it on the PostgreSQL 16, 15, 14 (i didn't try on others).
В списке pgsql-bugs по дате отправления: