Thread: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

From
gould@embl.de
Date:
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


Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

From
"Milen A. Radev"
Date:
gould@embl.de написа:
[...]
> 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?

Look here for "add_missing_from" -
http://www.postgresql.org/docs/8.1/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION


-- 
Milen A. Radev



Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

From
"A. Kretschmer"
Date:
am  Fri, dem 15.09.2006, um 11:16:06 +0200 mailte gould@embl.de folgendes:
> Is there some query optimization config setting I can set in pgsql 8.1.4 to fix

Yes. 'add_missing_from = true' in the postgresql.conf

http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html

But, you should rewrite your SQL...


HTH, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net