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 716.960017650@sss.pgh.pa.us
Whole thread Raw
In response to 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 have committed new warning code to alert users who auto-create
> relations without knowing it.
> The code issues the warning if it auto-creates a range table entry, and
> there is already a range table entry identified as coming from a FROM
> clause.  Correlated subqueries should not be a problem because they are
> not auto-created.

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...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: New warning code for missing FROM relations
Next
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] PostgreSQL v7.0.1 Released