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