Re: Query in postgreSQL version Windows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ardian Xharra \(Boxxo\)" <axharra(at)boxxo(dot)info>
Cc: pgsql-general(at)postgresql(dot)org, "Michael Fuhr" <mike(at)fuhr(dot)org>
Subject: Re: Query in postgreSQL version Windows
Date: 2006-01-03 15:32:12
Message-ID: 15945.1136302332@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ardian Xharra \(Boxxo\)" <axharra(at)boxxo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-01-03 15:33:50 Re: Forum Software
Previous Message Tom Lane 2006-01-03 15:27:23 Re: Problem restoring db-dump on Postgres 8.0.4 Power5