Truncate (logical replication)

Logical replication Truncate format. Identifies the message as a truncate message.

Reading PG 18·Select a recorded version

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

Definition PG 18

Byte1('T'): Identifies the message as a truncate message.
Int32 (TransactionId): Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2.
Int32: Number of relations
Int8: Option bits for TRUNCATE: 1 for CASCADE, 2 for RESTART IDENTITY
Int32 (Oid): OID of the relation corresponding to the ID in the relation message. This field is repeated for each relation.

Fields in documented order

Position	Format	Meaning
1	Byte1('T')	Identifies the message as a truncate message.
2	Int32 (TransactionId)	Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2.
3	Int32	Number of relations
4	Int8	Option bits for TRUNCATE : 1 for CASCADE , 2 for RESTART IDENTITY
5	Int32 (Oid)	OID of the relation corresponding to the ID in the relation message. This field is repeated for each relation.

Compare versions

Complete source facts

fields

map[description:Identifies the message as a truncate message. format:Byte1('T')], map[description:Xid of the transaction (only present for streamed transactions). This field is available since protocol version 2. format:Int32 (TransactionId)], map[description:Number of relations format:Int32], map[description:Option bits for TRUNCATE : 1 for CASCADE , 2 for RESTART IDENTITY format:Int8], map[description:OID of the relation corresponding to the ID in the relation message. This field is repeated for each relation. format:Int32 (Oid)]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f