Re: Strange permission problem regarding pg_settings - Mailing list pgsql-general

On Dec 10, 2003, at 5:35 PM, 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';

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

mfg, Florian Pflug