DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

/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()

Man(1) output converted with man2html