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  (Julien Rouhaud <rjuju123@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: RekGRpth
Дата:
Сообщение: Re: BUG #18247: Integer overflow leads to negative width
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: BUG #18251: Incorrect DROP VIEW pg_catalog.* behavior