From: vijay balan <vijay_gensec@yahoo.co.in>
To: pgsql-sql@postgresql.org
Subject: UnSubscribe
Date: Thu, 21 Sep 2006 05:47:34 +0100 (BST)
Message-ID: <20060921044734.59402.qmail@web8318.mail.in.yahoo.com> (raw)
gould@embl.de wrote: Date: Fri, 15 Sep 2006 11:16:06 +0200
From: gould@embl.de
To: pgsql-sql@postgresql.org
Subject: [SQL] Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
hi
I am upgrading from pgsql 7.4.1 to pgsql 8.1.4. However, some of the application
queries won't run on the newer version of pgsql.
An example of the type of query is:
SELECT
protein_external_links.protein_id, external_links.external_id,
proteins.public_name
WHERE
protein_external_links.external_link_id = external_links.id and
protein_external_links.protein_id = proteins.id and
external_links.external_database_id != 8 and
external_links.external_id_type_id = 2;
on pgsql7.4.1 what tables need to be queried seems to be implicitly deduced from
the rest of the SQL without the need for a FROM clause.
However, on pgsql 8.1.4 the following error is given:
ERROR: missing FROM-clause entry for table "protein_external_links"
Is there some query optimization config setting I can set in pgsql 8.1.4 to fix
this problem rather than having to change the queries in the code? I've read
over the changes between pgsql 7 and pgsql 8 but nothing seems to stand out to
me as referencing this problem. Anyone with more knowledge that can point me in
the right direction?
Thanks
Kate
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------------
Find out what India is talking about on - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it NOW
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vijay_gensec@yahoo.co.in
Subject: Re: UnSubscribe
In-Reply-To: <20060921044734.59402.qmail@web8318.mail.in.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox