/usr/man2/cat.l/commit_prepared.l.Z(/usr/man2/cat.l/commit_prepared.l.Z)

NAME

       COMMIT  PREPARED  -  commit a transaction that was earlier prepared for
       two-phase commit

SYNOPSIS

       COMMIT PREPARED transaction_id

DESCRIPTION

       COMMIT PREPARED commits a transaction that is in prepared state.

PARAMETERS

       transaction_id
              The transaction identifier of the transaction that is to be com-
              mitted.

NOTES

       To commit a prepared transaction, you must be either the same user that
       executed the transaction originally, or a superuser.  But  you  do  not
       have to be in the same session that executed the transaction.

       This  command  cannot  be executed inside a transaction block. The pre-
       pared transaction is committed immediately.

       All currently available prepared transactions are listed in the pg_pre-
       pared_xacts system view.

EXAMPLES

       Commit the transaction identified by the transaction identifier foobar:

       COMMIT PREPARED 'foobar';

SEE ALSO

       PREPARE TRANSACTION [prepare_transaction(l)], ROLLBACK PREPARED  [roll-
       back_prepared(l)]

SQL - Language Statements         2005-11-05                 COMMIT PREPARED()