1COMMIT PREPARED()                SQL Commands                COMMIT PREPARED()
2
3
4

NAME

6       COMMIT  PREPARED  -  commit a transaction that was earlier prepared for
7       two-phase commit
8
9

SYNOPSIS

11       COMMIT PREPARED transaction_id
12
13

DESCRIPTION

15       COMMIT PREPARED commits a transaction that is in prepared state.
16

PARAMETERS

18       transaction_id
19              The transaction identifier of the transaction that is to be com‐
20              mitted.
21

NOTES

23       To commit a prepared transaction, you must be either the same user that
24       executed the transaction originally, or a superuser.  But  you  do  not
25       have to be in the same session that executed the transaction.
26
27       This  command  cannot  be executed inside a transaction block. The pre‐
28       pared transaction is committed immediately.
29
30       All currently available prepared transactions are listed in the pg_pre‐
31       pared_xacts system view.
32

EXAMPLES

34       Commit the transaction identified by the transaction identifier foobar:
35
36       COMMIT PREPARED 'foobar';
37
38

SEE ALSO

40       PREPARE  TRANSACTION [prepare_transaction(7)], ROLLBACK PREPARED [roll‐
41       back_prepared(l)]
42
43
44
45SQL - Language Statements         2008-06-08                 COMMIT PREPARED()