projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b2db277) | patch
Transaction chaining
authorPeter Eisentraut <peter@eisentraut.org>
Sun, 24 Mar 2019 09:33:14 +0000 (10:33 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Sun, 24 Mar 2019 10:33:02 +0000 (11:33 +0100)
commit280a408b48d5ee42969f981bceb9e9426c3a344c
tree07cb0ab7cfdbb369e76130ef2cff56f65d0285a2tree
parentb2db277057a375ccbcc98cc3bbce8ce5b4d788eacommit | diff
Transaction chaining

Add command variants COMMIT AND CHAIN and ROLLBACK AND CHAIN, which
start new transactions with the same transaction characteristics as the
just finished one, per SQL standard.

Support for transaction chaining in PL/pgSQL is also added.  This
functionality is especially useful when running COMMIT in a loop in
PL/pgSQL.

Reviewed-by: Fabien COELHO <coelho@cri.ensmp.fr>
Discussion: https://www.postgresql.org/message-id/flat/28536681-324b-10dc-ade8-ab46f7645a5a@2ndquadrant.com
26 files changed:
doc/src/sgml/plpgsql.sgml diff | blob | blame | history
doc/src/sgml/ref/abort.sgml diff | blob | blame | history
doc/src/sgml/ref/commit.sgml diff | blob | blame | history
doc/src/sgml/ref/end.sgml diff | blob | blame | history
doc/src/sgml/ref/rollback.sgml diff | blob | blame | history
doc/src/sgml/spi.sgml diff | blob | blame | history
src/backend/access/transam/xact.c diff | blob | blame | history
src/backend/catalog/sql_features.txt diff | blob | blame | history
src/backend/executor/spi.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/equalfuncs.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/tcop/utility.c diff | blob | blame | history
src/bin/psql/tab-complete.c diff | blob | blame | history
src/include/access/xact.h diff | blob | blame | history
src/include/executor/spi.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/pl/plpgsql/src/expected/plpgsql_transaction.out diff | blob | blame | history
src/pl/plpgsql/src/pl_exec.c diff | blob | blame | history
src/pl/plpgsql/src/pl_funcs.c diff | blob | blame | history
src/pl/plpgsql/src/pl_gram.y diff | blob | blame | history
src/pl/plpgsql/src/pl_unreserved_kwlist.h diff | blob | blame | history
src/pl/plpgsql/src/plpgsql.h diff | blob | blame | history
src/pl/plpgsql/src/sql/plpgsql_transaction.sql diff | blob | blame | history
src/test/regress/expected/transactions.out diff | blob | blame | history
src/test/regress/sql/transactions.sql diff | blob | blame | history
Robert Haas's development tree.