[Pgpool-general] Order of Query Results

[Tatsuo Ishii]

> > Seems like pgpool issue. What I am wondering is this line:
> > > 2010-08-02 13:56:21 DEBUG: pid 19720: AsciiRow: len: 1 data: t
> > 
> > This suggests that your DB application uses very old PostgreSQL
> > protocol(call version 2 protocol), implemented in PostgreSQL 7.3 or
> > before. But you said your PostgreSQL is 8.4.4. Is there anything
> > special with your DB application?
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese: http://www.sraoss.co.jp
> 
> >Is there anything special with your DB application?
> 
> Ya, to put it nicely, it's old as dirt thanks to about a decade of bad 
> decisions by people who shouldn't be allowed to decide what to have for lunch.
> 
> Sorry, I forgot to add the primary user of that table is a custom ordering 
> system that currently runs Python 1.5 using _pg that was most likely built 
> against PostgreSQL before 7.2
> 
> I can try to see if we can move it to using something built against 8.3 (or 
> 8.4 if I can convince it to install on RHEL2.1) though, maybe in a week or 
> two. Is it possible that that is confusing pgpool?

I think it's possible. Version 2 protocol is hard to manage, fragile
and the code for the protcol in pgpool-II is complex. Using 8.3 or 8.4
(whatever version 7.4 or later) will make pgpool-II more robust and
efficient.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp