Re: add_missing_from breaks existing views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: add_missing_from breaks existing views
Дата
Msg-id 1328.1130297936@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: add_missing_from breaks existing views  (Neil Conway <neilc@samurai.com>)
Ответы Re: add_missing_from breaks existing views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> On Tue, 2005-25-10 at 17:43 -0400, Tom Lane wrote:
>> What I suggest we do about this is change addImplicitRTE() to set
>> inFromCl true for implicitly added RTEs, so that the view rule will
>> later be dumped as if the query had been written per spec.

> Sounds reasonable. I wonder if this should be backpatched -- ISTM the
> proper representation of the view is with an explicit FROM list anyway,

I think it'd be reasonable to back-patch it into the branches that have
the add_missing_from variable (how far back did we add that?).  But that
won't fix the problem with incompatible dump files from existing
installations.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The use of (mb)print.c from psql in the scripts directory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: add_missing_from breaks existing views