[pgpool-committers: 8892] pgpool: Fix ROLLBACK TO command to work in aborted transaction.

Tatsuo Ishii ishii at sraoss.co.jp
Fri Nov 25 18:28:04 JST 2022


Fix ROLLBACK TO command to work in aborted transaction.

Commit:

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=eea522ebfcf791a623e865deaa1aa6fb59e3c50b

fixed some cases in aborted transaction so that SQL commands except
COMMIT/ROLLBACK are not forwarded to backend. But it missed ROLLBACK
TO command. As a result even if ROLLBACK TO command is issued, the
command was not forwarded to backend and the transaction keeps on in
aborted state.
Back patched through 4.3 which the commit was brought in.
Also add a test case for ROLLBACK TO to test 078.
Discussion:
https://www.pgpool.net/pipermail/pgpool-general-jp/2022-November/001715.html

Branch
------
V4_3_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=b7b5bae8a91442afbfcacac7ce4e5f5882dcfc45

Modified Files
--------------
src/include/protocol/pool_proto_modules.h              |  1 +
src/protocol/pool_process_query.c                      | 17 ++++++++++++++++-
src/protocol/pool_proto_modules.c                      |  2 +-
.../tests/078.aborted_transaction/expected.txt         | 18 ++++++++++++++++++
.../regression/tests/078.aborted_transaction/test.sh   |  6 ++++++
5 files changed, 42 insertions(+), 2 deletions(-)



More information about the pgpool-committers mailing list