Search Postgresql Archives

Re: bug?: permission denied for schema on "on delete set null"

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

 





Tom Lane schrieb:
Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> writes:
I get a
Query failed: ERROR: permission denied for schema user_test CONTEXT:
SQL statement "UPDATE ONLY "user_test"."shop_commerce_baskets" SET
"sid" = NULL WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=)
"sid"::pg_catalog.text

This query is run when I do a
DELETE FROM user_test.sessions WHERE timestamp < 1236672815;
as a result of an

on delete set null

Queries for RI constraints are run with the permissions of the owner of
the other table.  It looks to me like the owner of user_test.sessions
doesn't have usage permission on schema user_test ...

			regards, tom lane

that's what I tried to say ;-) therfore the examples in my other posts ...

Cheers

Andy



--
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