Re: Strange permission problem regarding pg_settings

Tom Lane wrote:
> "Florian G. Pflug" <fgp@phlo.org> writes:
>>As user testuser (connected to testdb) :
>>.) update pg_settings set setting='public' where name='search_path' ;
>>this gives "pg_settings: permission denied"
>
> Hm.  Works fine here.  What do you get from
>
> select relacl, relacl is null from pg_class where relname = 'pg_settings';

Works fine here too, on RH9:

Welcome to psql 7.3.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help on internal slash commands
        \g or terminate with semicolon to execute query
        \q to quit

regression=# \c template1
You are now connected to database template1.
template1=# create user testuser password 'pw' nocreatedb nocreateuser;
CREATE USER
template1=# create database testdb owner testuser encoding 'utf-8';
CREATE DATABASE
template1=# \c testdb testuser
You are now connected to database testdb as user testuser.
testdb=> update pg_settings set setting='public' where name='search_path' ;
  set_config
------------
  public
(1 row)

testdb=> select relacl, relacl is null from pg_class where relname =
'pg_settings';
  relacl | ?column?
--------+----------
  {=r}   | f
(1 row)


Joe