[GENERAL] missing FROM-clause in version 9.2
Hi All, Getting an error in version 9.2 ERROR: missing FROM-clause entry for table for some queries. Server parameter add_missing_from is removed from version 9 as per release notes, so is there any workaround for fixing this issue? or is the better way is modifying all these queries ? Thanks for your help in Advance, Arun
Re: [GENERAL] missing FROM-clause in version 9.2
Arun P.L wrote: Getting an error in version 9.2 ERROR: missing FROM-clause entry for table for some queries. Server parameter add_missing_from is removed from version 9 as per release notes, so is there any workaround for fixing this issue? or is the better way is modifying all these queries ? The parameter has been off by default since version 8.1 and was removed in version 9.0. You will have to fix the queries. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] missing FROM-clause entry for table
On 12/11/2008 18:08, Erwin Moller wrote: LEFT OUTER JOIN tblcategorypropertylang AS CPL ON ((CLP.languageid=DRV1.languageid) AND (CPL.categorypropertyid=DRV1.categorypropertyid)); ERROR: missing FROM-clause entry for table clp You've a typo in the query - the table alias is CPL, not CLP. Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] missing FROM-clause entry for table
- Erwin Moller [EMAIL PROTECTED] wrote: Hi group, I get a mysterious errormessage while executing the following query: (I left the tabledefinitions out, since I think they don't matter. If I am wrong I'll be happy to post them.) SELECT DRV1.languageid, DRV1.categorypropertyid, CPL.categorypropertylangname FROM (SELECT L.languageid, CP.categorypropertyid FROM tbllanguage AS L, tblcategoryproperty AS CP) AS DRV1 LEFT OUTER JOIN tblcategorypropertylang AS CPL ON ((CLP.languageid=DRV1.languageid) AND ^^^ instead of CPL (CPL.categorypropertyid=DRV1.categorypropertyid)); ERROR: missing FROM-clause entry for table clp While this one is working just fine: SELECT DRV1.languageid, DRV1.categorypropertyid, categorypropertylangname FROM (SELECT L.languageid, CP.categorypropertyid FROM tbllanguage AS L, tblcategoryproperty AS CP) AS DRV1 LEFT OUTER JOIN tblcategorypropertylang ON ((tblcategorypropertylang.languageid=DRV1.languageid) AND (tblcategorypropertylang.categorypropertyid=DRV1.categorypropertyid)); The only difference is that I didn't use an alias CPL for tblcategorypropertylang. (The above queries are dynamically created by PHP based on a lot of other, not related, things, and I would like to use the first way because that makes sense in my current project.) I Googled a little for the errormessage, but to no avail. The second query is also good enough for me, but I am curious what I am missing here. What is causing this? Thanks for your time. Regards, Erwin Moller -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] missing FROM-clause entry for table
Hi group, I get a mysterious errormessage while executing the following query: (I left the tabledefinitions out, since I think they don't matter. If I am wrong I'll be happy to post them.) SELECT DRV1.languageid, DRV1.categorypropertyid, CPL.categorypropertylangname FROM (SELECT L.languageid, CP.categorypropertyid FROM tbllanguage AS L, tblcategoryproperty AS CP) AS DRV1 LEFT OUTER JOIN tblcategorypropertylang AS CPL ON ((CLP.languageid=DRV1.languageid) AND (CPL.categorypropertyid=DRV1.categorypropertyid)); ERROR: missing FROM-clause entry for table clp While this one is working just fine: SELECT DRV1.languageid, DRV1.categorypropertyid, categorypropertylangname FROM (SELECT L.languageid, CP.categorypropertyid FROM tbllanguage AS L, tblcategoryproperty AS CP) AS DRV1 LEFT OUTER JOIN tblcategorypropertylang ON ((tblcategorypropertylang.languageid=DRV1.languageid) AND (tblcategorypropertylang.categorypropertyid=DRV1.categorypropertyid)); The only difference is that I didn't use an alias CPL for tblcategorypropertylang. (The above queries are dynamically created by PHP based on a lot of other, not related, things, and I would like to use the first way because that makes sense in my current project.) I Googled a little for the errormessage, but to no avail. The second query is also good enough for me, but I am curious what I am missing here. What is causing this? Thanks for your time. Regards, Erwin Moller -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] missing FROM-clause entry for table
Raymond O'Donnell schreef: On 12/11/2008 18:08, Erwin Moller wrote: LEFT OUTER JOIN tblcategorypropertylang AS CPL ON ((CLP.languageid=DRV1.languageid) AND (CPL.categorypropertyid=DRV1.categorypropertyid)); ERROR: missing FROM-clause entry for table clp You've a typo in the query - the table alias is CPL, not CLP. Oh my /me slaps head against the wall. And I checked that query 2 times before posting here Maybe it is time to call it a day. ;-) Thanks Ray! (And Adrian) Regards, Erwin Moller Ray. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] missing FROM-clause
MaRCeLO PeReiRA wrote: Hi guys, I upgraded my PostgreSQL server (7.4 to 8.2) and now all my reports refuse to run because the warning missing FROM-clause. How can I disable it, just to run as the old version?? I have tried: # set add_missing_from to false but, without success!! :( set add_missing_from to true; You can also change this in the bottom of the postgresql.conf file. Then go through your code and fix the queries that require this. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] missing FROM-clause
Hi guys, I upgraded my PostgreSQL server (7.4 to 8.2) and now all my reports refuse to run because the warning missing FROM-clause. How can I disable it, just to run as the old version?? I have tried: # set add_missing_from to false but, without success!! :( The warning is still there!! Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
[GENERAL] missing FROM-clause (more)
Hi guys, (1) I change postgresql.conf: add_missing_from = off (2) pg_ctl stop (3) pg_ctl start Without success!! The warning is still there!! :( Any ideas Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] missing FROM-clause (more)
am Tue, dem 13.02.2007, um 9:46:26 -0300 mailte MaRCeLO PeReiRA folgendes: Hi guys, (1) I change postgresql.conf: add_missing_from = off (2) pg_ctl stop (3) pg_ctl start Without success!! The warning is still there!! :( Any ideas Change it to 'yes' ;-) And, of course, change your SQL-Syntax. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] missing FROM-clause entry
you didn't reference the table replica... this should work: UPDATE model_timemap SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map) FROM replica WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189 - Original Message - From: Brandon Metcalf [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, October 24, 2006 12:35 AM Subject: [GENERAL] missing FROM-clause entry Just upgraded to 8.1.5 and the following UPDATE causes the missing FROM-clause entry error: UPDATE model_timemap SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica = 32191 THEN 5739 ELSE -1 END, 1161642129, map) WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189 From what I've read, this typically results from referring to a table instead of it's alias, but I don't see how that applies here. -- Brandon ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ---(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
[GENERAL] missing FROM clause ?
Hello. In Postgres 8.1 I have a message that there is a missing FROM clause in the following query: select into l_validity "rok_valjanosti"."rok_valjanosti" FROM ( SELECT min("rok_valjanosti"."rv_id") AS "rv_id", "rok_valjanosti"."rok_valjanosti" FROM "rok_valjanosti" GROUP BY "rok_valjanosti"."rv_id", "rok_valjanosti"."rok_valjanosti") sve; If I change parameter "add missing from" in postgresl.conf to "on" than it works... I would like to include FROM clause, but can't see where. Thanks, Zlatko
Re: [GENERAL] missing FROM clause ?
Zlatko Matić wrote: Hello. In Postgres 8.1 I have a message that there is a missing FROM clause in the following query: select into l_validity rok_valjanosti.rok_valjanosti FROM ( SELECT min(rok_valjanosti.rv_id) AS rv_id, rok_valjanosti.rok_valjanosti FROM rok_valjanosti GROUP BY rok_valjanosti.rv_id, rok_valjanosti.rok_valjanosti) sve; If I change parameter add missing from in postgresl.conf to on than it works... I would like to include FROM clause, but can't see where. That subquery is called sve so I think you meant SELECT INTO l_validity svw.rok_valjanosti FROM ... -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly