Re: New warning code for missing FROM relations

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

But it seems mine is going to complain if they forget one in a FROM
clause, which sort of makes sense to me.   I can do your suggestion, but
this makes more sense.  Can we get some other votes?

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Giles Lean
Дата:
Сообщение: Re: Industrial-Strength Logging
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: Industrial-Strength Logging