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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
