Re: Fwd: Re: [GENERAL] Weird trouble with select

2010-06-29 Thread erobles
On 06/29/2010 10:19 AM, Adrian Klaver wrote: On Tuesday 29 June 2010 7:47:32 am erobles wrote: Hi!, thanks for your answer How many results are being returned for id=72 vs other ids? the tuples returned for id=72 are 91 (is too short :-( ), for id=71 are 94 for id=10 a

Re: Fwd: Re: [GENERAL] Weird trouble with select

2010-06-29 Thread Adrian Klaver
On Tuesday 29 June 2010 7:47:32 am erobles wrote: > > Hi!, thanks for your answer > > > How many results are being returned for id=72 vs other ids? > > the tuples returned for id=72 are 91 (is too short :-( ), for id=71 > are 94 for id=10 are 44. > > > How are 'B' and 'C' connecting to 'A'; psq

Re: Fwd: Re: [GENERAL] Weird trouble with select

2010-06-29 Thread erobles
Hi! I have 3 pc's: pc 'A' with postgres 7.2 running pc 'B' and 'C' connected to 'A' You should upgrade as quickly as possible. 7.2 is ancient. Even 8.1 will hit end-of-life soon. We are testing postgres 8.3.11 to detect any problem when we migrate from 7.2 :

Re: Fwd: Re: [GENERAL] Weird trouble with select

2010-06-29 Thread Adrian Klaver
On Tuesday 29 June 2010 7:22:56 am erobles wrote: > Original Message > Subject: Re: [GENERAL] Weird trouble with select > Date: Tue, 29 Jun 2010 09:13:14 -0500 > From: erobles > Organization: SENSA Control Digital > To: Joshua Tolley > > On 06/29/2