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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why can't select for update be used with join
Дата
Msg-id 11302.1068066821@sss.pgh.pa.us
обсуждение исходный текст
Ответ на why can't select for update be used with join  (Kris Kiger <kris@musicrebellion.com>)
Список 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 по дате отправления:

Предыдущее
От: Kris Kiger
Дата:
Сообщение: why can't select for update be used with join
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: performance problem - 10.000 databases