commit_prepared man page on Mandriva

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

COMMIT PREPARED(7)		 SQL Commands		    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 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(7)], ROLLBACK PREPARED [roll‐
       back_prepared(7)]

SQL - Language Statements	  2010-10-01		    COMMIT PREPARED(7)
[top]

List of man pages available for Mandriva

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