From: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
---|---|
To: | PGSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | superuser unable to modify settings of a system table |
Date: | 2010-06-03 16:43:12 |
Message-ID: | AANLkTikMyIgws7xbwSzt9aXbdZynDqvVoubH6MG_wJBP@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)gurjeet(at){ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet
Mail sent from my BlackLaptop device
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-06-03 17:02:23 | Re: superuser unable to modify settings of a system table |
Previous Message | Hartmut Goebel | 2010-06-03 16:04:16 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |