Delete (logical replication)

Logical replication Delete format. Identifies the message as a delete message.

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

10 11 12 13 14 15 16 17 18 19 20

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

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

版本定义 PG 18

Byte1('D'): Identifies the message as a delete message.
Int32 (TransactionId): Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2.
Int32 (Oid): OID of the relation corresponding to the ID in the relation message.
Byte1('K'): Identifies the following TupleData submessage as a key. This field is present if the table in which the delete has happened uses an index as REPLICA IDENTITY.
Byte1('O'): Identifies the following TupleData message as an old tuple. This field is present if the table in which the delete happened has REPLICA IDENTITY set to FULL.
TupleData: TupleData message part representing the contents of the old tuple or primary key, depending on the previous field.

The Delete message may contain either a 'K' message part or an 'O' message part, but never both of them.

Fields in documented order

Position	Format	Meaning
1	Byte1('D')	Identifies the message as a delete message.
2	Int32 (TransactionId)	Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2.
3	Int32 (Oid)	OID of the relation corresponding to the ID in the relation message.
4	Byte1('K')	Identifies the following TupleData submessage as a key. This field is present if the table in which the delete has happened uses an index as REPLICA IDENTITY.
5	Byte1('O')	Identifies the following TupleData message as an old tuple. This field is present if the table in which the delete happened has REPLICA IDENTITY set to FULL.
6	TupleData	TupleData message part representing the contents of the old tuple or primary key, depending on the previous field.

比较版本

完整来源事实

fields

map[description:Identifies the message as a delete message. format:Byte1('D')], map[description:Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2. format:Int32 (TransactionId)], map[description:OID of the relation corresponding to the ID in the relation message. format:Int32 (Oid)], map[description:Identifies the following TupleData submessage as a key. This field is present if the table in which the delete has happened uses an index as REPLICA IDENTITY. format:Byte1('K')], map[description:Identifies the following TupleData message as an old tuple. This field is present if the table in which the delete happened has REPLICA IDENTITY set to FULL. format:Byte1('O')], map[description:TupleData message part representing the contents of the old tuple or primary key, depending on the previous field. format:TupleData]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f