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@bigpanda.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"