pg_subscription_rel

字段

PostgreSQL 18 的 4 个字段，按定义顺序排列。说明默认用本站手册的译文，没有译文的按英文原文显示。

演化历史

相邻两个大版本之间的差异，新的在前。版本号链到该版的字段表。

1. PostgreSQL 19 ← 18 仅描述更新

   关系说明更新

   3 处描述更新

   • srrelid Reference to relation Reference to table or sequence
   • srsublsn Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null. For sequences, this instead holds the publisher sequence's page LSN as of the last synchronization, which does not track replication progress the way it does for tables; see Section 29.7.2 for how it is used to detect out-of-sync sequences.
   • srsubstate State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) State code for the table or sequence. State codes for tables: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication) State codes for sequences: i = initialize, r = ready

2. PostgreSQL 14 ← 13 仅描述更新

   1 处描述更新

   • srsubstate State code: i = initialize, d = data is being copied, s = synchronized, r = ready (normal replication) State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)

3. PostgreSQL 13 ← 12 结构变更

   srsublsn：非空 → 可空

4. PostgreSQL 10 ← 9.6 新增此关系

   共 4 个字段

字段矩阵

每个字段在 11 个收录版本里的存在情况；方格指向该版的字段表。「有变」指类型、可空、隐式或数组维数与上一版不同。

存在 有变 已移除 不存在

系统列

同类关系