Re: " Adding missing FROM-clause entry for table .... " problem.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: " Adding missing FROM-clause entry for table .... " problem.
Дата
Msg-id 23712.1045582810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: " Adding missing FROM-clause entry for table .... " problem.  (Tomasz Myrta <jasiek@klaster.net>)
Список pgsql-sql
Tomasz Myrta <jasiek@klaster.net> writes:
> Christoph Haller wrote:
>> is not valid SQL syntax. What will actually happen (this is a PostgreSQL
>> extension to the standard) is that an implicit table
>> reference is added to the FROM clause, so the query is processed as if
>> it were written as

> I think this extension should be removed.

I don't think it's likely to get removed any time soon.
Maybe a workable compromise would be to add a GUC parameter
"allow_implicit_from", with options "ok" (completely permissive),
"notice" (the current behavior), and "error" (disallow it).

But we'd have to do something about the DELETE syntax before the
"error" setting would be real useful.
        regards, tom lane


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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: " Adding missing FROM-clause entry for table .... " problem.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: " Adding missing FROM-clause entry for table .... " problem.