Unable to delete row on 7.3.2 with schemas

Поиск
Список
Период
Сортировка
От Fernando Schapachnik
Тема Unable to delete row on 7.3.2 with schemas
Дата
Msg-id 20030227142959.GA329@bal740r0.mecon.gov.ar
обсуждение исходный текст
Ответы Re: Unable to delete row on 7.3.2 with schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Raphael Bauduin
Дата:
Сообщение: pgsql + chroot + RAID5 performance?
Следующее
От: Emmanuel Dreyfus
Дата:
Сообщение: password method in pg_hba.conf fails