Re: [GENERAL] missing FROM-clause in version 9.2

2013-06-24 Thread Albe Laurenz
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 the

[GENERAL] missing FROM-clause in version 9.2

2013-06-24 Thread Arun P . L
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 ? T

Re: [GENERAL] missing FROM-clause entry for table

2008-11-12 Thread Erwin Moller
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 -

Re: [GENERAL] missing FROM-clause entry for table

2008-11-12 Thread Adrian Klaver
- "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.categorypro

Re: [GENERAL] missing FROM-clause entry for table

2008-11-12 Thread Raymond O'Donnell
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

[GENERAL] missing FROM-clause entry for table

2008-11-12 Thread Erwin Moller
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,

Re: [GENERAL] missing FROM-clause

2007-02-15 Thread Richard Huxton
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 ad

Re: [GENERAL] missing FROM-clause (more)

2007-02-13 Thread A. Kretschmer
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 c

[GENERAL] missing FROM-clause (more)

2007-02-13 Thread MaRCeLO PeReiRA
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 Yaho

[GENERAL] missing FROM-clause

2007-02-13 Thread MaRCeLO PeReiRA
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!! Th

Re: [GENERAL] missing FROM-clause entry

2006-10-23 Thread Brandon Metcalf
m == [EMAIL PROTECTED] writes: m> you didn't reference the table "replica"... this should work: m> UPDATE model_timemap m> SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica = m> 32191 THEN 5739 ELSE -1 END, 1161642129, map) m> FROM replica m> WHERE replica.replica_id

Re: [GENERAL] missing FROM-clause entry

2006-10-23 Thread Thomas H.
a.proxy = 32189 - Original Message - From: "Brandon Metcalf" <[EMAIL PROTECTED]> To: 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" e

[GENERAL] missing FROM-clause entry

2006-10-23 Thread Brandon Metcalf
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

Re: [GENERAL] missing FROM clause ?

2005-10-27 Thread Richard Huxton
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 B

[GENERAL] missing FROM clause ?

2005-10-27 Thread Zlatko Matić
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_valjano