Skip site navigation (1) Skip section navigation (2)

Re: BUG #3277: error occurs between different versions

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Nilay Ceter <nilayceter(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3277: error occurs between different versions
Date: 2007-05-14 08:57:17
Message-ID: 20070514085717.GB20472@svr2.hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, May 14, 2007 at 09:44:05AM +0100, Heikki Linnakangas wrote:
> Nilay Ceter wrote:
> >The command line:
> >
> >select seri_no, ad as baslik, kull_ref as Kullanıcı_Referansi, 
> >sorumlu
> >from onay,dokuman where p_id='yonetici' and onay.dokuman_id=dokuman.seri_no
> >and onay_durum.seri_no=seri_no and onay_durum.p_id='yonetici' and
> >(dokuman.durum=1 or dokuman.durum=2 or dokuman.durum=6 or dokuman.durum=7)
> >and onay_durum.durum=0 and seri_no>0
> >
> >
> >was working properly in Postgre SQL 8.0 but in version Postgre SQL 8.2 the
> >second "and" gives an error.
> >And it is :
> >
> >" Project dym.exe raised exception class EPSQLDatabaseError with message
> >'PostgreSQL Error Code : (1)
> >ERROR: missing FROM-clause entry for table "onay_durum" at character 152'
> >.Process stopped.Use Step or Run to continue. "
> 
> I don't understand how that query could have worked on PostgreSQL 8.0 
> either. There's no table or alias with name "onay_durum" in the FROM clause.
> 
> Are you sure this is the exactly same query you tried on PostgreSQL 8.0?

Seems to be dependant on the config parameter add_missing_from. The default
changed between 8.0 and 8.1 from on to off.

Nilay, you can try setting add_missing_from=on in postgresql.conf and
reload the service to fix this. Or better yet, fix your query to reference
all tables in the from clause.

//Magnus


In response to

pgsql-bugs by date

Next:From: Klint GoreDate: 2007-05-14 09:07:19
Subject: Re: BUG #3277: error occurs between different versions
Previous:From: Heikki LinnakangasDate: 2007-05-14 08:44:05
Subject: Re: BUG #3277: error occurs between different versions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group