From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
---|---|
To: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: bug?: permission denied for schema on "on delete set null" |
Date: | 2009-03-10 13:31:56 |
Message-ID: | 49B66BCC.2030601@netzmeister-st-pauli.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2009-03-10 13:42:45 | Re: postgresql and LDAP |
Previous Message | Emanuel Calvo Franco | 2009-03-10 13:11:46 | Re: postgresql and LDAP |