Re: Permission denied for relation pg_database , one role has problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pg(at)awot(dot)fi
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Permission denied for relation pg_database , one role has problem
Date: 2012-08-25 16:01:24
Message-ID: 9201.1345910484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jukka Inkeri <pg(at)awot(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2012-08-26 04:11:23 Re: create table like . . . constraint names
Previous Message Edson Richter 2012-08-25 12:56:38 Re: Postgresql 9.1 on VMWare ESXi 5.0