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 |
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 |