GNU.WIKI: The GNU/Linux Knowledge Base

  [HOME] [PHP Manual] [HowTo] [ABS] [MAN1] [MAN2] [MAN3] [MAN4] [MAN5] [MAN6] [MAN7] [MAN8] [MAN9]

  [0-9] [Aa] [Bb] [Cc] [Dd] [Ee] [Ff] [Gg] [Hh] [Ii] [Jj] [Kk] [Ll] [Mm] [Nn] [Oo] [Pp] [Qq] [Rr] [Ss] [Tt] [Uu] [Vv] [Ww] [Xx] [Yy] [Zz]


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
           committed.

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
       prepared transaction is committed immediately.

       All currently available prepared transactions are listed in the
       pg_prepared_xacts system view.

EXAMPLES

       Commit the transaction identified by the transaction identifier foobar:

           COMMIT PREPARED 'foobar';

COMPATIBILITY

       COMMIT PREPARED is a PostgreSQL extension. It is intended for use by
       external transaction management systems, some of which are covered by
       standards (such as X/Open XA), but the SQL side of those systems is not
       standardized.

SEE ALSO

       PREPARE TRANSACTION (PREPARE_TRANSACTION(7)), ROLLBACK PREPARED
       (ROLLBACK_PREPARED(7))



  All copyrights belong to their respective owners. Other content (c) 2014-2018, GNU.WIKI. Please report site errors to webmaster@gnu.wiki.
Page load time: 0.196 seconds. Last modified: November 04 2018 12:49:43.