Re: select oid .... for update ....

This is a known problem in 7.0.x (see mailing list archives for more
information). Peter E has a patch for 7.1 to remove this problem.

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Sun, 15 Oct 2000, KuroiNeko wrote:

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