On Mon, 14 May 2007 09:44:05 +0100, Heikki Linnakangas <heikki@enterprisedb=
.com> wrote:
> Nilay Ceter wrote:
> > The command line:
> >
> > select seri_no, ad as baslik, kull_ref as Kullan=C4=B1c=C4=B1_Referansi=
, sorumlu
> > from onay,dokuman where p_id=3D'yonetici' and onay.dokuman_id=3Ddokuman=
.seri_no
> > and onay_durum.seri_no=3Dseri_no and onay_durum.p_id=3D'yonetici' and
> > (dokuman.durum=3D1 or dokuman.durum=3D2 or dokuman.durum=3D6 or dokuman=
.durum=3D7)
> > and onay_durum.durum=3D0 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 15=
2'
> > .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 clau=
se.
>
> 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@kgb.une.edu.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 : :
+---------------------------------------+-----------------+