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

BUG #3277: error occurs between different versions

From: "Nilay Ceter" <nilayceter(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3277: error occurs between different versions
Date: 2007-05-14 08:30:17
Message-ID: 200705140830.l4E8UHtB023534@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3277
Logged by:          Nilay Ceter
Email address:      nilayceter(at)gmail(dot)com
PostgreSQL version: 8.2.3
Operating system:   windows
Description:        error occurs between different versions
Details: 

We are developing a network based application, using postgre sql.

Earlier version has been developed using Postgre SQL 8.0 and there was no
problem.

But we use Postgre SQL 8.2 in new version and we are experiencing some
problems about our sql commands.

The command line:

select seri_no, ad as baslik, kull_ref as Kullanc_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. "

would you please help us?

Best Regards

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-05-14 08:44:05
Subject: Re: BUG #3277: error occurs between different versions
Previous:From: michaelDate: 2007-05-14 07:27:19
Subject: BUG #3276: unique index/unique constraint

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