forked from docs/doc-exports
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
3.2 KiB
3.2 KiB
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
1 | 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
Parent topic: TCL Syntax