And many others errors when xsome user connect to database x, schema
xxx. PG 8.4.
Problems started about same time as search_path has SET.
search_path has reset, but did'nt help.
ALTER DATABASE x SET search_path=some, public;
-- xxx wasn't in that list
ALTER DATABASE x RESET search_path; - has
Jukka Inkeri writes:
> Only one group has this priviledge problem, xgroup.
> pg_log after tried to connect:
> 2012-08-25 11:39:36 EEST ERROR: permission denied for relation pg_database
> 2012-08-25 11:39:36 EEST STATEMENT: SET DateStyle=ISO;
> SELECT oid, pg_encoding_to_char(encoding) AS e
And many others errors when xsome user connect to database x, schema
xxx. PG 8.4.
Problems started about same time as search_path has SET.
search_path has reset, but did'nt help.
ALTER DATABASE x SET search_path=some, public;
-- xxx wasn't in that list
ALTER DATABASE x RESET search_path; - has
