select oid .... for update ....
KuroiNeko <evpopkov@carrier.kiev.ua>
From: KuroiNeko <evpopkov@carrier.kiev.ua>
To: pgsql-hackers@postgresql.org
Date: 2000-10-15T15:10:08Z
Lists: pgsql-hackers
Attachments
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)