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

From Tom Lane
Subject Re: Strange permission problem regarding pg_settings
Date
Msg-id 6933.1071074138@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange permission problem regarding pg_settings  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Strange permission problem regarding pg_settings  ("Florian G. Pflug" <fgp@phlo.org>)
Re: Strange permission problem regarding pg_settings  (Joe Conway <mail@joeconway.com>)
List pgsql-general
"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';


            regards, tom lane

pgsql-general by date:

Previous
From: Christopher.Becker@apcc.com
Date:
Subject: "PostgreSQL Error Code(1)"
Next
From: Tom Lane
Date:
Subject: Re: highest match in group