Commit Prepared (logical replication)

说明

逻辑复制 Commit Prepared 格式，表示提交预备事务消息。

层次

逻辑复制载荷，与前后端消息封装分开。

首个字段

Byte1('K')

用法

Commit Prepared

协议上下文

本节说明各逻辑复制消息的详细格式。这些消息由复制槽 SQL 接口返回，或由 walsender 发送。由 walsender 发送时，它们被封装在复制协议的 WAL 消息中（参见第 54.4 节），消息流程通常与物理复制相同。Stream Start、Stream Stop、Stream Commit 和 Stream Abort 从协议版本 2 起可用。Begin Prepare、Prepare、Commit Prepared、Rollback Prepared 和 Stream Prepare 从协议版本 3 起可用。以下消息部分为上述消息所共用。

相关条目

• 流复制协议
• 逻辑解码插件

文档与源码

• PostgreSQL 18 English manual

版本比较

PostgreSQL 14 → 15: 新增收录。

以下差异保留原始字段名与英文源描述。

--- PostgreSQL 14
+++ PostgreSQL 15
@@ -1 +1,33 @@
-该版未收录
+{
+  "fields": [
+    {
+      "description": "Identifies the message as the commit of a prepared transaction message.",
+      "format": "Byte1('K')"
+    },
+    {
+      "description": "Flags; currently unused.",
+      "format": "Int8(0)"
+    },
+    {
+      "description": "The LSN of the commit of the prepared transaction.",
+      "format": "Int64 (XLogRecPtr)"
+    },
+    {
+      "description": "The end LSN of the commit of the prepared transaction.",
+      "format": "Int64 (XLogRecPtr)"
+    },
+    {
+      "description": "Commit timestamp of the transaction. The value is in number of microseconds since PostgreSQL epoch (2000-01-01).",
+      "format": "Int64 (TimestampTz)"
+    },
+    {
+      "description": "Xid of the transaction.",
+      "format": "Int32 (TransactionId)"
+    },
+    {
+      "description": "The user defined GID of the prepared transaction.",
+      "format": "String"
+    }
+  ],
+  "layer": "logical replication"
+}

比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。

相关条目

• Begin (logical replication)
• Begin Prepare (logical replication)
• Commit (logical replication)
• Delete (logical replication)
• Insert (logical replication)
• Message (logical replication)
• Origin (logical replication)
• Prepare (logical replication)
• Relation (logical replication)
• Rollback Prepared (logical replication)
• Stream Abort (logical replication)
• Stream Commit (logical replication)