select oid .... for update ....

From: KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua>
To: pgsql-hackers(at)postgresql(dot)org
Subject: select oid .... for update ....
Date: 2000-10-15 15:10:08
Message-ID: 39E9C8D0.nail1FJ11UCUV@ed.ed
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Here's something I don't understand.... If I'm missing an obvious, please
feel free to kick me in the right direction.
We're given two tables, linked with a foreign key. When insert is run on a
master table, everything is OK, when trying to insert into a detail table,
a strange query appears in the log (schema and log snippet attached).
In fact, there should be no problem, but if a user has no permissions to
update the master table (eg, this is a log where he can only insert, but
neither delete, nor update), then inserting into detail table fails on
permission violation at the query:

SELECT oid FROM "alpha" WHERE "id" = $1 FOR UPDATE OF "alpha"

TIA

Ed

---
Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known

Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)

Attachment Content-Type Size
t.sql text/plain 1016 bytes
pgsql text/plain 7.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-15 15:57:32 Re: AW: ALTER TABLE DROP COLUMN
Previous Message Martin A. Marques 2000-10-15 15:00:39 Re: WAL status & todo