From 9ca5c8721dfa2413e910531373395c6e18062ddf Mon Sep 17 00:00:00 2001 From: Michael Meskes Date: Mon, 13 Mar 2017 20:48:29 +0100 Subject: [PATCH] Document two phase commit commands in ecpg docu. Patch by Masahiko Sawada --- doc/src/sgml/ecpg.sgml | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index b8021cbe5b..bc4dd68620 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -507,6 +507,35 @@ EXEC SQL COMMIT; + + + EXEC SQL PREPARE TRANSACTION transaction_id + + + Prepare the current transaction for two-phase commit. + + + + + + + EXEC SQL COMMIT PREPARED transaction_id + + + Commit a transaction that is in prepared state. + + + + + + EXEC SQL ROLLBACK PREPARED transaction_id + + + Roll back a transaction that is in prepared state. + + + + EXEC SQL SET AUTOCOMMIT TO ON -- 2.39.5