[Pgpool-general] Is pgpool compatible with protocolVersion=3 of jdbc?

[Nimesh Satam]

Tatsuo,

>> What error do you have with temp table creation?

When we try to create temp table using pgpool, the application fails with
below error:

*"ERROR: kind mismatch among backends. Possible last query was: "..." kind
details are: 0[1] 1[E]" error.*

We are using pgpool in master-slave mode and loadbalance=on.

On execution of the below queries the above error appears:

*1) CREATE TEMP TABLE tmp_ch (key integer PRIMARY KEY); *

*2) INSERT INTO tmp_ch (key) SELECT key FROM rpt_ch WHERE id IN (135848,
135841);*

Note: in logs we see the first query getting Parsed on master and slave
database. But the execute is done only on slave. As a result the 2 query
fails.

Let me know if you need any information

Regards,
Nimesh.


On Wed, Aug 26, 2009 at 5:52 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Is there any significant difference in using pg connection string
> > "protocolVersion=2"?
> >
> > By default pg driver uses protocol V3, this causes the temp table
> creation
> > from application to fail.
>
> What error do you have with temp table creation?
>
> > If we change the connection string to
> > "protocolVersion=2" everything works fine
> >
> > eg: Connection c =
> >
> DriverManager.getConnection("jdbc:postgresql://db_host:db_port/reporting?protocolVersion=2","car",
> > "");
> >
> > Is there any negative impact of using protocolversion 2.
>
> Yes. Protocolversion 2 is inefficient comparing with 3. Also you will
> lose some important features those are available with only 3. For
> example, load balance, insert lock etc.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090826/2743e4f7/attachment.html>