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

2009-03-10 Thread Ivan Sergio Borgonovo
On Tue, 10 Mar 2009 13:12:03 -0400 Tom Lane wrote: > Ivan Sergio Borgonovo 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(p

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

2009-03-10 Thread Andreas Wenk
Tom Lane schrieb: Ivan Sergio Borgonovo 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

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

2009-03-10 Thread Tom Lane
Ivan Sergio Borgonovo 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 d

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

2009-03-10 Thread Andreas Wenk
Ivan Sergio Borgonovo schrieb: On Tue, 10 Mar 2009 14:31:56 +0100 Andreas Wenk wrote: which rights does the actual user have for the schema user_test? > Query failed: ERROR: permission denied for schema user_test > CONTEXT: I think the user does not have the rights for the schema ... I j

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

2009-03-10 Thread Ivan Sergio Borgonovo
On Tue, 10 Mar 2009 14:31:56 +0100 Andreas Wenk wrote: > which rights does the actual user have for the schema user_test? > > > Query failed: ERROR: permission denied for schema user_test > > CONTEXT: > > I think the user does not have the rights for the schema ... I just run http://pgedit.c

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

2009-03-10 Thread Andreas Wenk
Ivan Sergio Borgonovo schrieb: 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 DEL

[GENERAL] bug?: permission denied for schema on "on delete set null"

2009-03-10 Thread Ivan Sergio Borgonovo
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 t