Thread: pgsql: Fix bug in COMMIT AND CHAIN command.
Fix bug in COMMIT AND CHAIN command. This commit fixes COMMIT AND CHAIN command so that it starts new transaction immediately even if savepoints are defined within the transaction to commit. Previously COMMIT AND CHAIN command did not in that case because commit 280a408b48 forgot to make CommitTransactionCommand() handle a transaction chaining when the transaction state was TBLOCK_SUBCOMMIT. Also this commit adds the regression test for COMMIT AND CHAIN command when savepoints are defined. Back-patch to v12 where transaction chaining was added. Reported-by: Arthur Nascimento Author: Fujii Masao Reviewed-by: Arthur Nascimento, Vik Fearing Discussion: https://postgr.es/m/16867-3475744069228158@postgresql.org Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/422012c98f8d929f9aa2b2e706b29512f61544e1 Modified Files -------------- src/backend/access/transam/xact.c | 7 ++++++ src/test/regress/expected/transactions.out | 40 ++++++++++++++++++++++++++++++ src/test/regress/sql/transactions.sql | 11 ++++++++ 3 files changed, 58 insertions(+)