Postgres Pro
Downloads
Home   >   mailing lists

Re: Permission denied for relation pg_database , one role has problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Permission denied for relation pg_database , one role has problem
Date
Msg-id 9201.1345910484@sss.pgh.pa.us
Whole thread Raw
In response to Permission denied for relation pg_database , one role has problem  (Jukka Inkeri <pg@awot.fi>)
List pgsql-general
Tree view 
Jukka Inkeri <pg@awot.fi> 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 encoding, datlastsysoid
>        FROM pg_database WHERE oid = 16395

Either you messed up the permissions on that catalog, or you created
another table named pg_database ...

            regards, tom lane

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: Postgresql 9.1 on VMWare ESXi 5.0
Next
From: Vincent Veyron
Date:
Subject: Re: create table like . . . constraint names