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

2003-11-05 Thread Tom Lane
Kris Kiger <[EMAIL PROTECTED]> 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 t

[ADMIN] why can't select for update be used with join

2003-11-05 Thread Kris Kiger
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 ---(end of broadcast)--- TIP 8: explain anal