COMMIT_PREPARED man page on OpenSuSE

Man page or keyword search:  
man Server   25941 pages
apropos Keyword Search (all sections)
Output format
OpenSuSE logo
[printable version]

COMMIT PREPARED(7)	PostgreSQL 9.2.4 Documentation	    COMMIT PREPARED(7)

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

PostgreSQL 9.2.4		  2013-04-01		    COMMIT PREPARED(7)
[top]

List of man pages available for OpenSuSE

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net