end.7

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

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "END" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
END \- commit the current transaction

.SH SYNOPSIS
.sp
.nf
END [ WORK | TRANSACTION ]
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBEND\fR commits the current transaction. All changes
made by the transaction become visible to others and are guaranteed
to be durable if a crash occurs. This command is a
PostgreSQL extension
that is equivalent to COMMIT [\fBcommit\fR(7)].
.SH "PARAMETERS"
.TP
\fBWORK\fR
.TP
\fBTRANSACTION\fR
Optional key words. They have no effect.
.SH "NOTES"
.PP
Use ROLLBACK [\fBrollback\fR(7)] to
abort a transaction.
.PP
Issuing \fBEND\fR when not inside a transaction does
no harm, but it will provoke a warning message.
.SH "EXAMPLES"
.PP
To commit the current transaction and make all changes permanent:
.sp
.nf
END;
.sp
.fi
.SH "COMPATIBILITY"
.PP
\fBEND\fR is a PostgreSQL
extension that provides functionality equivalent to COMMIT [\fBcommit\fR(7)], which is
specified in the SQL standard.
.SH "SEE ALSO"
BEGIN [\fBbegin\fR(7)], COMMIT [\fBcommit\fR(l)], ROLLBACK [\fBrollback\fR(l)]