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

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
> DELETE FROM user_test.sessions WHERE timestamp < 1236672815;
> as a result of an
>
> on delete set null
>
> but when I directly do a
>
> update user_test.shop_commerce_baskets set sid=null;
>
> I get no error.
>
> create table user_test.sessions(
>   sid int primary key,
> );
>
> create table user_test.shop_commerce_baskets (
>   sid int references sessions (sid) on delete set null,
>   ...
> );
>
> I'm on PostgreSQL 8.3.6 (Debian Lenny).
>
> thanks
>

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

Cheers

Andy

--

St.Pauli - Hamburg - Germany

Andreas Wenk