Re: New warning code for missing FROM relations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: New warning code for missing FROM relations
Date
Msg-id 4445.960050677@sss.pgh.pa.us
Whole thread Raw
In response to Re: New warning code for missing FROM relations  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: New warning code for missing FROM relations  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Industrial-Strength Logging
Next
From: Bruce Momjian
Date:
Subject: Re: New warning code for missing FROM relations