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 ----- Original Message ----- From: "Michael Fuhr" <mike@xxxxxxxx> To: "Ardian Xharra (Boxxo)" <axharra@xxxxxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> Sent: Monday, January 02, 2006 4:29 PM Subject: Re: [GENERAL] Query in postgreSQL version Windows > On Mon, Jan 02, 2006 at 04:01:56PM -0500, Ardian Xharra (Boxxo) wrote: > > I installed PostgreSQL on windows and when I try to run some > > queries pgadmin says an error. > > What version of PostgreSQL? What's the exact error message? That > often provides a clue as to what's wrong. I'll guess that the > Windows box is running 8.1.x and the error is: > > ERROR: missing FROM-clause entry for table "pg_class" > > > I know that if I change the query this it will work but is it > > possible to make this quey work in this way > > Why don't you want to rewrite the query? > > > SELECT atthasdef > > FROM pg_attribute > > WHERE attrelid=pg_class.oid AND pg_class.relname='client_overtime' AND attname='id_client_overtime' > > > > This query works fine in PostgreSQL (Linux-Unix platform) > > Another guess: the Linux box is running a version of PostgreSQL > older than 8.1, or if it's running 8.1 then you've enabled > add_missing_from. As the 8.1 Release Notes mention, that option > is now disabled by default. Rather than trying to make the query > work as-is, rewrite it to be proper SQL by adding pg_class to the > FROM clause. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 02/01/2006 > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 02/01/2006
