Re: New warning code for missing FROM relations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: New warning code for missing FROM relations
Дата
Msg-id 4445.960050677@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: New warning code for missing FROM relations  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: New warning code for missing FROM relations  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> I still prefer the suggestion I made before: complain only if the
>> implicit FROM entry is for a table already present in the rangelist
>> (under a different alias, obviously).  The fact that that choice
>> would not break any existing regression tests seems relevant...

> But it seems mine is going to complain if they forget one in a FROM
> clause, which sort of makes sense to me.

Seems like the real question is what is the goal of having the warning.
Are we (a) trying to nag people into writing their queries in an
SQL-compliant way, or are we (b) trying to warn about probable mistakes
while still considering implicit FROM entries as a fully supported
Postgres feature?

If the goal is (a) then your way is better, but I like mine if the goal
is (b).  Seems like some discussion is needed here about just what we
want to accomplish.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Industrial-Strength Logging
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: New warning code for missing FROM relations