Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux