ROLLBACK
Description
Rolls back the current transaction and backs out all updates in the transaction.
If a fault occurs during the running of a transaction, the transaction cannot be executed. The system cancels all completed operations on the database in the transaction, and the database status returns to the time when the transaction starts.
Precautions
If a ROLLBACK statement is executed out of a transaction, no error occurs, but a notice is displayed.
Syntax
ROLLBACK [ WORK | TRANSACTION ];
Parameters
WORK | TRANSACTION
Specifies the optional keyword that more clearly illustrates the syntax.
Examples
-- Start a transaction. openGauss=# START TRANSACTION; -- Back out all changes. openGauss=# ROLLBACK;
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot