Re: missing FROM-clause - Mailing list pgsql-general

From Richard Huxton
Subject Re: missing FROM-clause
Date
Msg-id 45D43DFF.2050101@archonet.com
Whole thread Raw
In response to missing FROM-clause  (MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>)
List 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 by date:

Previous
From: Dave Page
Date:
Subject: Re: Stored Procedure examples
Next
From: Peter Eisentraut
Date:
Subject: Re: Stored Procedure examples