{"Entry":{"collection":"catalog","key":"pg_subscription_rel","name":"pg_subscription_rel","aliases":[],"metadata":{"changed_in":["13"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[{"attribute":"not_null","from":true,"name":"srsublsn","to":false}],"description_changed":false,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"State code: i = initialize, d = data is being copied, s = synchronized, r = ready (normal replication)","name":"srsubstate","to":"State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Reference to relation","name":"srrelid","to":"Reference to table or sequence"},{"from":"Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null","name":"srsublsn","to":"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."},{"from":"State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)","name":"srsubstate","to":"State code for the table or sequence.\n\nState codes for tables: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)\n\nState codes for sequences: i = initialize, r = ready"}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":4,"content_hash":"410da0bd2cd0d4bfc3e1be805217a1afc29f2a484671c64eee0dfa5daa99a5e5","derived_content_hash":"c87c6e321b5924d736b5536492f2ba11b2997cb98e0aa55695ef9e2da51ef4eb","first_version":"10","imported_at":"2026-09-30T00:40:56.250601+08:00","kind":"catalog","last_version":"20","name":"pg_subscription_rel","position":137,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:b8215bebb4d7387ee0555cd59fac9c95ea53281388631f3a96e7112d8de4656b","summary":"The catalog pg_subscription_rel contains the state for each replicated relation in each subscription.","summary_zh":"目录 pg_subscription_rel 存储每个订阅中各个被复制的表和序列的状态。这是一种多对多映射。"}},"Definition":{"Collection":"catalog","Key":"pg_subscription_rel","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_subscription_rel","SourceRevision":"catalog-bilingual-repair:b8215bebb4d7387ee0555cd59fac9c95ea53281388631f3a96e7112d8de4656b","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Reference to subscription","description_zh":"对订阅的引用","documented":true,"documented_name":"srsubid","hidden":false,"name":"srsubid","not_null":true,"references":"pg_subscription.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Reference to relation","description_zh":"对关系的引用","documented":true,"documented_name":"srrelid","hidden":false,"name":"srrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)","description_zh":"状态代码：i = 初始化，d = 数据正在被复制，f = 已完成表复制，s = 已同步，r = 就绪（正常复制）","documented":true,"documented_name":"srsubstate","hidden":false,"name":"srsubstate","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null","description_zh":"在 s 或 r 状态中，用于同步协调的状态更改的远程 LSN，否则为 NULL","documented":true,"documented_name":"srsublsn","hidden":false,"name":"srsublsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220,"zh_from":"same-version-manual"}],"description":"The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.\n\nThis catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION.","description_zh":"目录 pg_subscription_rel 包含每个订阅中每个被复制关系的状态。这是一种多对多映射。\n\n此目录只包含在运行 CREATE SUBSCRIPTION 或 ALTER SUBSCRIPTION ... REFRESH PUBLICATION 之后，对该订阅已知的表。","description_zh_html":"\u003cp\u003e目录 pg_subscription_rel 包含每个订阅中每个被复制关系的状态。这是一种多对多映射。\u003c/p\u003e\n\u003cp\u003e此目录只包含在运行 CREATE SUBSCRIPTION 或 ALTER SUBSCRIPTION ... REFRESH PUBLICATION 之后，对该订阅已知的表。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.57.5","file":"catalog-pg-subscription-rel.html","lang":"en","sha256":"6784595cb96c017b7e3e585fa65e3cdc7525a831e3491b8eca85bc6fecc4b601","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["srsubid","srrelid","srsubstate","srsublsn"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-subscription-rel.html","sha256":"0b752eed141e63528c4fbb814139821630cb5e2433563ad31fda0253161744a2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:d60d3256d3581ba8337460aea264be5a116022a7b2d212746278d7ea9e350f39","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.57.5","file":"catalog-pg-subscription-rel.html","lang":"en","sha256":"6784595cb96c017b7e3e585fa65e3cdc7525a831e3491b8eca85bc6fecc4b601","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-subscription-rel.html","sha256":"0b752eed141e63528c4fbb814139821630cb5e2433563ad31fda0253161744a2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:d60d3256d3581ba8337460aea264be5a116022a7b2d212746278d7ea9e350f39","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["srsubid","srrelid","srsubstate","srsublsn"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_subscription_rel","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_subscription_rel","Summary":"The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.\n\nThis catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION.","BodyHTML":"\u003cp\u003eThe catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.\n\nThis catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:b8215bebb4d7387ee0555cd59fac9c95ea53281388631f3a96e7112d8de4656b","ContentHash":"8164184dd877b15a82157c7a6ef8029520a021b8e51bf3b93d516d09e329e1cf","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Reference to subscription","description_zh":"对订阅的引用","documented":true,"documented_name":"srsubid","hidden":false,"name":"srsubid","not_null":true,"references":"pg_subscription.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Reference to relation","description_zh":"对关系的引用","documented":true,"documented_name":"srrelid","hidden":false,"name":"srrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"State code: i = initialize, d = data is being copied, f = finished table copy, s = synchronized, r = ready (normal replication)","description_zh":"状态代码：i = 初始化，d = 数据正在被复制，f = 已完成表复制，s = 已同步，r = 就绪（正常复制）","documented":true,"documented_name":"srsubstate","hidden":false,"name":"srsubstate","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Remote LSN of the state change used for synchronization coordination when in s or r states, otherwise null","description_zh":"在 s 或 r 状态中，用于同步协调的状态更改的远程 LSN，否则为 NULL","documented":true,"documented_name":"srsublsn","hidden":false,"name":"srsublsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220,"zh_from":"same-version-manual"}],"description":"The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping.\n\nThis catalog only contains tables known to the subscription after running either CREATE SUBSCRIPTION or ALTER SUBSCRIPTION ... REFRESH PUBLICATION."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}