Unable to delete row on 7.3.2 with schemas

From: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to delete row on 7.3.2 with schemas
Date: 2003-02-27 14:29:59
Message-ID: 20030227142959.GA329@bal740r0.mecon.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres 7.3.2:

table2 has a foreign key on table1 (id).

Trying to delete a value from table1, not actually referenced from table2.

psql -U usr db

db=> DELETE FROM table1 WHERE id=7;
LOG: query: DELETE FROM table1 WHERE id=7;
LOG: query: SELECT 1 FROM ONLY "public"."table1" x WHERE "id" = $1 FOR UPDATE
OF x
LOG: query: SELECT 1 FROM ONLY "public"."table2" x WHERE "id" = $1 FOR UPDATE
OF x
ERROR: usr: permission denied

db=> \dp table2

Access privileges for database "db"
Schema | Table | Access privileges
--------+------------+-------------------------------------------------------------------
public | table2 | {=,...,usr=arwd,...}
(1 row)

db=> \db table1
Access privileges for database "db"
Schema | Table | Access privileges
--------+------------+-------------------------------------------------------------------
public | table1 | {=,...,usr=arwd,...}
(1 row)

Same happens if I do this as db super-user. "usr" is also an schema name.

Can't see why. Any ideas? Some obvious overlook?

Thanks in advance!

Fernando Schapachnik
Proyecto de Informática
Ministerio de Economía

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Harnett 2003-02-27 14:57:59 Pg_dump Help
Previous Message Peter Gibbs 2003-02-27 14:13:16 Re: PGSQL function question