commit_prepared.7

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· 7 代码 · 共 44 行

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "COMMIT PREPARED" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
COMMIT PREPARED \- commit a transaction that was earlier prepared for two-phase commit

.SH SYNOPSIS
.sp
.nf
COMMIT PREPARED \fItransaction_id\fR
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBCOMMIT PREPARED\fR commits a transaction that is in 
prepared state.
.SH "PARAMETERS"
.TP
\fB\fItransaction_id\fB\fR
The transaction identifier of the transaction that is to be
committed.
.SH "NOTES"
.PP
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.
.PP
This command cannot be executed inside a transaction block. The prepared
transaction is committed immediately.
.PP
All currently available prepared transactions are listed in the
\fBpg_prepared_xacts\fR
system view.
.SH "EXAMPLES"
.PP
Commit the transaction identified by the transaction
identifier foobar:
.sp
.nf
COMMIT PREPARED 'foobar';
.sp
.fi
.SH "SEE ALSO"
PREPARE TRANSACTION [\fBprepare_transaction\fR(7)], ROLLBACK PREPARED [\fBrollback_prepared\fR(l)]