From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
---|---|
To: | Nilay Ceter <nilayceter(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3277: error occurs between different versions |
Date: | 2007-05-14 08:44:05 |
Message-ID: | 46482155.9030100@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2007-05-14 08:57:17 | Re: BUG #3277: error occurs between different versions |
Previous Message | Nilay Ceter | 2007-05-14 08:30:17 | BUG #3277: error occurs between different versions |