PostgreSQL ROLLBACK

相關問題 & 資訊整理

PostgreSQL ROLLBACK

ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. Parameters. WORK TRANSACTION. Optional key words ... ,ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. Parameters. WORK TRANSACTION. Optional key words ... ,Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ... ,Notes. Use COMMIT to successfully terminate a transaction. Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning ... ,Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. Examples. To abort all changes: ROLLBACK;. Compatibility. The SQL ... ,Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ... ,Notes. To roll back a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. ,The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension. See Also. BEGIN, COMMIT, ROLLBACK TO SAVEPOINT ... ,Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ... ,ROLLBACK 命令: ... ROLLBACK命令是用於撤消交易尚未保存到數據庫的事務命令。 ROLLBACK命令隻能用於自上次發出COMMIT或ROLLBACK命令撤消事務。 ROLLBACK命令的 ...

相關軟體 PostgreSQL 資訊

PostgreSQL
PostgreSQL 是一個跨平台的對象關係型數據庫管理系統,自 1995 年首次發布以來,已經成長為國際知名的解決方案,可幫助管理員輕鬆創建,組織,管理和部署各種形狀和大小的項目數據庫。這當然包括對運行 SQL 查詢,觸發管理,屬性管理以及其他企業級數據庫管理系統當前正在使用的所有功能的全面控制。為使日常管理多個作業和項目組件的管理員更容易訪問,PostgreSQL 符合大多數 SQL 2008... PostgreSQL 軟體介紹

PostgreSQL ROLLBACK 相關參考資料
Documentation: 9.4: ROLLBACK - PostgreSQL

ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. Parameters. WORK TRANSACTION. Optional key words ...

https://www.postgresql.org

Documentation: 8.1: ROLLBACK - PostgreSQL

ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. Parameters. WORK TRANSACTION. Optional key words ...

https://www.postgresql.org

Documentation: 9.5: ROLLBACK TO SAVEPOINT - PostgreSQL

Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ...

https://www.postgresql.org

Documentation: 9.1: ROLLBACK - PostgreSQL

Notes. Use COMMIT to successfully terminate a transaction. Issuing ROLLBACK when not inside a transaction does no harm, but it will provoke a warning ...

https://www.postgresql.org

Documentation: 9.6: ROLLBACK - PostgreSQL

Issuing ROLLBACK outside of a transaction block emits a warning and otherwise has no effect. Examples. To abort all changes: ROLLBACK;. Compatibility. The SQL ...

https://www.postgresql.org

Documentation: 9.1: ROLLBACK TO SAVEPOINT - PostgreSQL

Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ...

https://www.postgresql.org

Documentation: 9.3: ROLLBACK PREPARED - PostgreSQL

Notes. To roll back a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser.

https://www.postgresql.org

Documentation: 13: ROLLBACK - PostgreSQL

The command ROLLBACK conforms to the SQL standard. The form ROLLBACK TRANSACTION is a PostgreSQL extension. See Also. BEGIN, COMMIT, ROLLBACK TO SAVEPOINT ...

https://www.postgresql.org

Documentation: 8.2: ROLLBACK TO SAVEPOINT - PostgreSQL

Description. Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again ...

https://www.postgresql.org

PostgreSQL事務- PostgreSQL教學 - 極客書

ROLLBACK 命令: ... ROLLBACK命令是用於撤消交易尚未保存到數據庫的事務命令。 ROLLBACK命令隻能用於自上次發出COMMIT或ROLLBACK命令撤消事務。 ROLLBACK命令的 ...

http://tw.gitbook.net