Обсуждение: missing FROM-clause

Поиск
Список
Период
Сортировка

missing FROM-clause

От
MaRCeLO PeReiRA
Дата:
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!! :(

The warning is still there!!

Thanks in advance,

Marcelo Pereira

__________________________________________________
Fale com seus amigos  de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/

Re: missing FROM-clause

От
Richard Huxton
Дата:
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