NAME

END - 提交當(dāng)前的事務(wù)

SYNOPSIS

END [ WORK | TRANSACTION ]

DESCRIPTION 描述

END END 提交當(dāng)前事務(wù)。 所有當(dāng)前事務(wù)做的修改都可被其它事務(wù)看到并且保證在發(fā)生崩潰的情況下的持續(xù)性。 它是一個(gè) PostgreSQL 的擴(kuò)展，等效于 COMMIT [commit(7)].  

PARAMETERS 參數(shù)

WORK

TRANSACTION

 可選關(guān)鍵字。沒有作用。

NOTES 注意

 用 ROLLBACK [rollback(7)] 退出事務(wù)。

 如果不在一個(gè)事務(wù)塊里發(fā)出 END 將不會(huì)有什么損害，但是它會(huì)生成一個(gè)警告信息。  

EXAMPLES 例子

 提交當(dāng)前事務(wù)，令所有改變生效：

END;

COMPATIBILITY 兼容性

END 是 PostgreSQL 的擴(kuò)展，提供與 COMMIT [commit(7)] 相同的功能， 后者是 SQL 標(biāo)準(zhǔn)聲明的語句。  

SEE ALSO 參見

BEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)]

#p#

NAME

END - commit the current transaction

SYNOPSIS

END [ WORK | TRANSACTION ]

DESCRIPTION

END 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 [commit(7)].  

PARAMETERS

WORK

TRANSACTION

Optional key words. They have no effect.

NOTES

Use ROLLBACK [rollback(7)] to abort a transaction.

Issuing END when not inside a transaction does no harm, but it will provoke a warning message.  

EXAMPLES

To commit the current transaction and make all changes permanent:

END;

COMPATIBILITY

END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.  

SEE ALSO

BEGIN [begin(7)], COMMIT [commit(l)], ROLLBACK [rollback(l)]