Re: Help or Bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: Help or Bug?
Date
Msg-id 27612.1066445868@sss.pgh.pa.us
Whole thread Raw
In response to Help or Bug?  (Cláudia Morgado <claudia.morgado@widesoft.com.br>)
List pgsql-general
=?iso-8859-1?Q?Cl=E1udia_Morgado?= <claudia.morgado@widesoft.com.br> writes:
> CREATE SCHEMA wlog_data AUTHORIZATION wlog_data;
> ...
> 5=BA) Now We try to create the foreing key  :
> ERROR: wlog_data: permission denied

I think you forgot to grant USAGE on the wlog_data schema to the other
user.  This permission bit doesn't have any equivalent in Oracle AFAIK,
but it corresponds to execute permission on a Unix directory, if that
helps you at all...

            regards, tom lane

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Postgres seems to BE on windowsXP
Next
From: Tom Lane
Date:
Subject: Re: Using subselects in INSERTs?