BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql)

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql)
Дата
Msg-id 18281-5b1b6c5991d345aa@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18281: Superuser can rename the schema with the prefix "pg_" (Applies to all versions of postgresql)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18281
Logged by:          Maciej Szeliga
Email address:      szyjek9302@gmail.com
PostgreSQL version: 16.1
Operating system:   centos 8
Description:

Hi, 
I renamed the schema pg_toast 
moja=# alter schema pg_toast rename to x_pg_toast
moja-# ;
ALTER SCHEMA

and can't undo it because :

moja=# alter schema x_pg_toast rename to pg_toast;
ERROR: unacceptable schema name "pg_toast"
DETAIL: The prefix "pg_" is reserved for system schemas.

I think this is a serious problem that should be fixed by developers. The
superuser should not be able to rename system schemas.

Regards
Maciej


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18280: logical decoding build wrong snapshot for subtransactions
Следующее
От: "feichanghong"
Дата:
Сообщение: Re:BUG #18280: logical decoding build wrong snapshot for subtransactions