Updated on 2025-07-22 GMT+08:00

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

Table 1 COMMIT PREPARED parameters

Parameter

Description

transaction_id

Identifier of the transaction to be committed. The identifier cannot be the same as any identifier used by the current prepared transaction.

CSN(commit sequence number)

Sequence number of the transaction to be committed. The value is a 64-bit ascending unsigned number.