Re: Query in postgreSQL version Windows - Mailing list pgsql-general

From Tom Lane
Subject Re: Query in postgreSQL version Windows
Date
Msg-id 15945.1136302332@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query in postgreSQL version Windows  ("Ardian Xharra \(Boxxo\)" <axharra@boxxo.info>)
List pgsql-general
"Ardian Xharra \(Boxxo\)" <axharra@boxxo.info> writes:
> Yes it is the version 8.1.1 and the error is
> ERROR:  missing FROM-clause entry for table "pg_class"
> I have too many queries like this in my program and I was thinking maybe is
> the fault of installation like I missed something. Is there anything I can
> do or it's
> the wrong way I was doing the queries in SQL

You can set add_missing_from = true to reproduce the pre-8.1 behavior,
but in the long run you'd be better off fixing your code.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem restoring db-dump on Postgres 8.0.4 Power5
Next
From: Scott Marlowe
Date:
Subject: Re: Forum Software