Rollback Prepared (logical replication)

Logical replication Rollback Prepared format. Identifies the message as the rollback of a prepared transaction message.

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义，以下显示原始英文内容。

Layer: Logical replication payload; distinct from the frontend/backend message envelope
First field: Byte1('r')
manual path: /docs/18/protocol-logicalrep-message-formats.html
signature: Rollback Prepared

版本定义 PG 18

Byte1('r'): Identifies the message as the rollback of a prepared transaction message.
Int8(0): Flags; currently unused.
Int64 (XLogRecPtr): The end LSN of the prepared transaction.
Int64 (XLogRecPtr): The end LSN of the rollback of the prepared transaction.
Int64 (TimestampTz): Prepare timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).
Int64 (TimestampTz): Rollback timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).
Int32 (TransactionId): Xid of the transaction.
String: The user defined GID of the prepared transaction.

Fields in documented order

Position	Format	Meaning
1	Byte1('r')	Identifies the message as the rollback of a prepared transaction message.
2	Int8(0)	Flags; currently unused.
3	Int64 (XLogRecPtr)	The end LSN of the prepared transaction.
4	Int64 (XLogRecPtr)	The end LSN of the rollback of the prepared transaction.
5	Int64 (TimestampTz)	Prepare timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).
6	Int64 (TimestampTz)	Rollback timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).
7	Int32 (TransactionId)	Xid of the transaction.
8	String	The user defined GID of the prepared transaction.

比较版本

完整来源事实

fields

map[description:Identifies the message as the rollback of a prepared transaction message. format:Byte1('r')], map[description:Flags; currently unused. format:Int8(0)], map[description:The end LSN of the prepared transaction. format:Int64 (XLogRecPtr)], map[description:The end LSN of the rollback of the prepared transaction. format:Int64 (XLogRecPtr)], map[description:Prepare timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). format:Int64 (TimestampTz)], map[description:Rollback timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01). format:Int64 (TimestampTz)], map[description:Xid of the transaction. format:Int32 (TransactionId)], map[description:The user defined GID of the prepared transaction. format:String]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f