Re: missing FROM-clause

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: missing FROM-clause
Дата
Msg-id 45D43DFF.2050101@archonet.com
обсуждение исходный текст
Ответ на missing FROM-clause  (MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>)
Список pgsql-general
MaRCeLO PeReiRA wrote:
> Hi guys,
>
> I upgraded my PostgreSQL server (7.4 to 8.2) and now
> all my reports refuse to run because the warning
> "missing FROM-clause".
>
> How can I disable it, just to run as the old version??
>
> I have tried:
>
> # set add_missing_from to false
>
> but, without success!! :(

set add_missing_from to true;

You can also change this in the bottom of the postgresql.conf file.

Then go through your code and fix the queries that require this.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Stored Procedure examples
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Stored Procedure examples