superuser unable to modify settings of a system table

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема superuser unable to modify settings of a system table
Дата
Msg-id AANLkTikMyIgws7xbwSzt9aXbdZynDqvVoubH6MG_wJBP@mail.gmail.com
обсуждение исходный текст
Ответы Re: superuser unable to modify settings of a system table
Список pgsql-bugs
On PG 8.4.4 I am unable to set per-table autovacuum setting for the
pg_listener table. Being a superuser, I'd expect Postgres to allow me to do
that.

postgres=# select version();

version
-----------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.3.2
20081105 (Red Hat 4.3.2-7), 32-bit
(1 row)

postgres=# select user;
 current_user
--------------
 postgres
(1 row)

postgres=# alter table pg_listener set (autovacuum_vacuum_threshold=100);
ERROR:  permission denied: "pg_listener" is a system catalog
postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ********
|          |
(1 row)

Regards,
PS: RhodiumToad prompted me to post here.
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.EnterpriseDB.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #5364: citext behavior when type not in public schema
Следующее
От: Tom Lane
Дата:
Сообщение: Re: superuser unable to modify settings of a system table