Help Center/ GaussDB(DWS)/ More Documents/ SQL Syntax Reference (Kuala Lumpur Region)/ TCL Syntax/ ROLLBACK PREPARED
Updated on 2022-08-16 GMT+08:00
View PDF
Share

ROLLBACK PREPARED

Function

ROLLBACK PREPARED cancels a transaction ready for two-phase committing.

Precautions

  • The function is only available in maintenance mode (when GUC parameter xc_maintenance_mode is on). Exercise caution when enabling the mode. It is used by maintenance engineers for troubleshooting. Common users should not use the mode.
  • Only the user that initiates a transaction or the system administrator can roll back the transaction.
  • The transaction function is maintained automatically by the database, and should be not visible to users.

Syntax

ROLLBACK PREPARED transaction_id ;

Parameter Description

transaction_id

Specifies the identifier of the transaction to be submitted. The identifier must be different from those for current prepared transactions.

Helpful Links

COMMIT PREPARED, PREPARE TRANSACTION

Parent topic: TCL Syntax