Re: why can't select for update be used with join - Mailing list pgsql-admin

From Tom Lane
Subject Re: why can't select for update be used with join
Date
Msg-id 11302.1068066821@sss.pgh.pa.us
Whole thread Raw
In response to why can't select for update be used with join  (Kris Kiger <kris@musicrebellion.com>)
List pgsql-admin
Kris Kiger <kris@musicrebellion.com> writes:
> I'm trying to do a query:  select ta.x from ta join tb using (y) where z
> = 'somevalue' FOR UPDATE

> Why can't this be executed without error in 7.3.x?  It worked just fine
> in 7.2.x.   Thanks for the input

Try saying "FOR UPDATE OF ta, tb".

I agree there's no real reason the system should be that pedantic,
however.  Will see about fixing this for 7.4.

            regards, tom lane

pgsql-admin by date:

Previous
From: Kris Kiger
Date:
Subject: why can't select for update be used with join
Next
From: "scott.marlowe"
Date:
Subject: Re: performance problem - 10.000 databases