Re: New warning code for missing FROM relations
| От | Tom Lane |
|---|---|
| Тема | Re: New warning code for missing FROM relations |
| Дата | |
| Msg-id | 716.960017650@sss.pgh.pa.us обсуждение |
| Ответ на | New warning code for missing FROM relations (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: New warning code for missing FROM relations
|
| Список | 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 по дате отправления: