[pgpool-committers: 1604] pgpool: Fix jdbc DML fails when operated in raw mode and auto commit is

Tatsuo Ishii ishii at postgresql.org
Sun Jan 19 12:08:32 JST 2014


Fix jdbc DML fails when operated in raw mode and auto commit is off.

When autocommit is off, bind() needs to start a transaction (if not
already in) for DMLs and do an insert lock if sequences are used in
replication mode. The fix was made into pgpool-II
3.3.2. Unfortunately, the fix forgot that it should be applied only
for replication mode. For other mode, that is not needed at all. The
bug reported in #92 happens when operated in raw mode and auto commit
is off.  When parse() executes it does not start a transaction because
we are in raw mode.  Then bind() starts a transaction by issuing
"BEGIN" which destroys the unnamed statement and the failure occurs.

Per bug #92.

Branch
------
V3_2_STABLE

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=8b3e46e0ed2b61fb32458192ed1ae626bceb3e40

Modified Files
--------------
pool_proto_modules.c |   37 ++++++++++++++++++++-----------------
1 file changed, 20 insertions(+), 17 deletions(-)



More information about the pgpool-committers mailing list