Re: why can't select for update be used with join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Kiger <kris(at)musicrebellion(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: why can't select for update be used with join
Date: 2003-11-05 21:13:41
Message-ID: 11302.1068066821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kris Kiger <kris(at)musicrebellion(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Juan Miguel 2003-11-05 21:44:45 Re: Microsoft access verses postgresql
Previous Message scott.marlowe 2003-11-05 21:05:49 Re: performance problem - 10.000 databases