Search Postgresql Archives

Re: error "permission denied for relation" on postgresql 9.0.6 during CREATE TABLE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Il giorno ven, 27/01/2012 alle 08.54 -0800, Adrian Klaver ha scritto:
> On Friday, January 27, 2012 8:25:56 am Giuseppe Sacco wrote:
[...]
> > I am owner of table "documents":
> > 
> > neos=> \dt agenzia.documents
> >           List of relations
> >  Schema  |   Name    | Type  | Owner
> > ---------+-----------+-------+-------
> >  agenzia | documents | table | neos
> > (1 row)
> > 
> > I read the documentation about postgresql 9.0 and it seems the error
> > message is about permission "x". As you may see "x" is among my
> > permissions:
> 
> The x(REFERENCES) permission needs to be on both tables for the owner of the 
> referenced table(noes).

Well, I am owner of the referenced table. I cannot check anything on the
barcodebydocumentinfo table since it is the one I am trying to CREATE.

Thanks,
Giuseppe


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux