> 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
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
