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¶
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.