[Pgpool-general] Order of Query Results

[Sean Brown]

On Thursday, August 05, 2010 06:26:46 pm Tatsuo Ishii wrote:
> > > 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

Alright, we'll move to psycopg built against 8.3 as soon as we can get back to 
the list with results.