Re: FOR UPDATE versus WITH --- change 8.4 too?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FOR UPDATE versus WITH --- change 8.4 too?
Дата
Msg-id 12369.1256663645@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FOR UPDATE versus WITH --- change 8.4 too?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: FOR UPDATE versus WITH --- change 8.4 too?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> If it doesn't have any effect anyway, what's the virtue of back-patching it?

Because 8.4 just fails in cases where we can easily allow it to work
according to the new definition.  Right now, if you want to use FOR
UPDATE in a query that has WITHs, you have to carefully write
FOR UPDATE OF x,y,z,... for all the non-WITH relations.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Parsing config files in a directory
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Parsing config files in a directory