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

Re: BUG #3277: error occurs between different versions

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Nilay Ceter <nilayceter(at)gmail(dot)com>
Subject: Re: BUG #3277: error occurs between different versions
Date: 2007-05-14 09:07:19
Message-ID: 464826C729D.0924KG@129.180.47.120 (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, 14 May 2007 09:44:05 +0100, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> 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?

Didn't the default in postgresql.conf for add_missing_from change in 8.1?

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg(at)kgb(dot)une(dot)edu(dot)au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+

In response to

Responses

pgsql-bugs by date

Next:From: Laurent FAILLIEDate: 2007-05-14 12:00:29
Subject: RE : Re: BUG #3271: PREPARE/EXCUTE don't work
Previous:From: Magnus HaganderDate: 2007-05-14 08:57:17
Subject: Re: BUG #3277: error occurs between different versions

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