[pgpool-committers: 1603] pgpool: Fix jdbc DML fails when operated in raw mode and auto commit is
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.
pool_proto_modules.c | 30 +++++++++++++++++++++++++++++-
1 file changed, 29 insertions(+), 1 deletion(-)
More information about the pgpool-committers