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