Re: Fix for tablename in targetlist
| От | Tom Lane |
|---|---|
| Тема | Re: Fix for tablename in targetlist |
| Дата | |
| Msg-id | 262.990286418@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: Fix for tablename in targetlist (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: Fix for tablename in targetlist
|
| Список | pgsql-hackers |
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Seems a tablename with no FROM clause doesn't get marked as isRel
> because it is not in the range table to be matched.
> What would happen if we added auto-star is that a table name in a target
> list would automatically become tablename.*. Seems it is too prone to
> cause bad queries to be accepted.
No; the auto-star would only happen if the thing is marked isRel.
So it would just cover the case of "select tab from tab". It seems
reasonable to me --- what other possible interpretation of the meaning
is there?
I tend to agree that we should not change the code to make "select tab"
work, on the grounds of error-proneness.
regards, tom lane
В списке pgsql-hackers по дате отправления: