[Pgpool-general] Transactions not working properly from ODBC

[Tatsuo Ishii]

Right. That's the reason why we cannot drop version 2 protocol.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> It seems that there's no PostgreSQL ODBC driver that supports version 3
> protocol, since the one I have is the latest I could find. If you know
> where can I find it, would be great!
> 
> I'll keep searching anyway.
> 
> Thanks,
> Daniel
> 
> -----Original Message-----
> From: Jaume Sabater [mailto:jsabater at gmail.com] 
> Sent: Thursday, March 12, 2009 4:20 AM
> To: Tatsuo Ishii
> Cc: Crespo, Daniel @ SDS; pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] Transactions not working properly from
> ODBC
> 
> On Thu, Mar 12, 2009 at 1:23 AM, Tatsuo Ishii <ishii at sraoss.co.jp>
> wrote:
> 
> > The difference between psql and ODBC is the protocol version
> > number. Namely psql speaks version 3 which is standard protocol since
> > PostgreSQL 7.4, while your ODBC driver speaks version 2, which is
> > pretty old.
> >
> > Unfortunately pgpool-II 2.2 seems to have a problem with insert_lock
> > handling used with version 2 protocol.
> 
> Don't want to sound like a pain in the neck but, is it worth
> supporting version 2 these days?
> 
> -- 
> Jaume Sabater
> http://linuxsilo.net/
> 
> "Ubi sapientas ibi libertas"