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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
