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

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: bug?: permission denied for schema on "on delete set null"
Date: 2009-03-10 12:36:26
Message-ID: 20090310133626.454a9951@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2009-03-10 12:37:21 Re: 8.3.6 build error on Debian Lenny
Previous Message Gregory Stark 2009-03-10 12:23:49 Re: postgresql and LDAP