COMMIT PREPARED
Function
COMMIT PREPARED commits a prepared two-phase transaction.
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 transaction creators or system administrators can run the COMMIT command. The creation and commit operations must be in different sessions.
- The transaction function is maintained automatically by the database, and should be not visible to users.
Syntax
1 2 |
COMMIT PREPARED transaction_id ; COMMIT PREPARED transaction_id WITH CSN; |
Parameter Description
- transaction_id
Specifies the identifier of the transaction to be submitted. The identifier must be different from those for current prepared transactions.
- CSN(commit sequence number)
Specifies the sequence number of the transaction to be committed. It is a 64-bit, incremental, unsigned number.
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.