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

Tatsuo Ishii ishii at postgresql.org
Tue Feb 11 23:50:15 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.

Branches
--------
EXCEPTION_MGR
master

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

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



More information about the pgpool-committers mailing list