Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-21 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > (Someone who knows more than I do might comment on what happens > to unqualfied field names when the add missing from brings in another > field with the same name?) Nothing --- it's always been the case that unqualified field names have to reference one of

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-21 Thread Klint Gore
I'm suprised it worked in 8.0. You should have got column reference is ambiguous errors on seri_no since it appears in both dokuman and onay_durum and there are 3 places where you don't specify which one you want. (Someone who knows more than I do might comment on what happens to unqualfied field

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-18 Thread Heikki Linnakangas
nilay çeter wrote: Yes,it is the same query, and had worked on PostgreSQL8.0 ,but although I had already added "onay_durum" to from clause and it did not work on 8.2,I have changed the 'add_missing_from = off ' and made it on in conf. file but it didn't work too. I have no idea about what to do:

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Klint Gore
On Mon, 14 May 2007 09:44:05 +0100, Heikki Linnakangas <[EMAIL PROTECTED]> 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

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Magnus Hagander
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=

Re: [BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Heikki Linnakangas
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 dokum

[BUGS] BUG #3277: error occurs between different versions

2007-05-14 Thread Nilay Ceter
The following bug has been logged online: Bug reference: 3277 Logged by: Nilay Ceter Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: windows Description:error occurs between different versions Details: We are developing a network based a