[pgpool-committers: 1855] pgpool: Fix backend error of prepared statement including now() via JDB

Muhammad Usama m.usama at gmail.com
Tue May 6 20:08:10 JST 2014


Fix backend error of prepared statement including now() via JDBC in replication mode

With JDBC, when a prepared statement is executed more than PreparedThreshold times,
the statement is named, and pgpool rewrites now() to parameter in replication mode.
Hence, rewritten query has additonal parameter, so Bind message also should inclued
additional parameter format codes. However, when the number of original parameter was
one, pgpool didn't handle this. This caused a error like "incorrect binary data format
in bind parameter 2" on backend.

Branch
------
EXCEPTION_MGR

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=3c55eeeb482b903bbc3fc8825cd99349dee7b123
Author: Yugo Nagata <nagata at sraoss.co.jp>

Modified Files
--------------
src/rewrite/pool_timestamp.c |   35 +++++++++++++++++++++++++++--------
1 file changed, 27 insertions(+), 8 deletions(-)



More information about the pgpool-committers mailing list