Postgres Pro
Downloads
Home   >   mailing lists

Re: missing FROM-clause in version 9.2 - Mailing list pgsql-general

From Albe Laurenz
Subject Re: missing FROM-clause in version 9.2
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BB5E4C@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to missing FROM-clause in version 9.2  (Arun P.L <arunpl@hotmail.com>)
List pgsql-general
Tree view 
Arun P.L wrote:
> Getting an error in version 9.2 "ERROR: missing FROM-clause entry for table" for some queries. Server
> parameter  "add_missing_from" is removed from version 9 as per release notes, so is there any
> workaround for fixing this issue? or is the better way is modifying all these queries ?

The parameter has been "off" by default since version 8.1
and was removed in version 9.0.

You will have to fix the queries.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Stuart Ford
Date:
Subject: pg_largeobject.sql script not run after upgrade
Next
From: boraldomaster
Date:
Subject: Re: Index scan and bitmap index scan - hard to understand how planner chooses