Search Postgresql Archives

Re: permission denied for schema

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

 



jef peeraer <jef.peeraer@xxxxxxxxxx> writes:
> i get this when i try to insert a record into a table. all permissions / 
> privileges seems ok, but probably i missed something. i am running a 
> 8.1.3 on linux.

> registratie=> INSERT INTO clienten 
> (anoniem,geslacht,leeftijd,origine,team_id,hulpverlener_id) VALUES 
> ('true','45','58','864','30','221');
> ERROR:  permission denied for schema deterp
> CONTEXT:  SQL statement "SELECT 1 FROM ONLY "deterp"."teams" x WHERE 
> "id" = $1 FOR SHARE OF x"

That's a foreign-key check, which is supposed to be done as the owner of
the table.  You did not show us who owns table clienten, but I think
that role must be missing the intended(?) membership in deterp_group.

			regards, tom lane


[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