Re: why can't select for update be used with join - Mailing 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