{"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":"42a42521a69f6dd2c310e0b088d3bf9aafccc6ff7f9cb49ef705c645d2b340c7","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":"english-manuals:d60d3256d3581ba8337460aea264be5a116022a7b2d212746278d7ea9e350f39","summary":"The catalog pg_subscription_rel contains the state for each replicated relation in each subscription.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_subscription_rel","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_subscription_rel","SourceRevision":"english-manuals:d60d3256d3581ba8337460aea264be5a116022a7b2d212746278d7ea9e350f39","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},{"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},{"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":"","documented":true,"documented_name":"srsubstate","hidden":false,"name":"srsubstate","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"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":"","documented":true,"documented_name":"srsublsn","hidden":false,"name":"srsublsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.57.5","file":"catalog-pg-subscription-rel.html","lang":"en","sha256":"6784595cb96c017b7e3e585fa65e3cdc7525a831e3491b8eca85bc6fecc4b601","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_subscription_rel","Summary":"目录pg_subscription_rel包含每个订阅中每个被复制关系的状态。这是一种多对多映射。\n\n此目录只包含在运行CREATE SUBSCRIPTION或ALTER SUBSCRIPTION ... REFRESH PUBLICATION之后，对该订阅已知的表。","BodyHTML":"\u003cp\u003e目录pg_subscription_rel包含每个订阅中每个被复制关系的状态。这是一种多对多映射。\n\n此目录只包含在运行CREATE SUBSCRIPTION或ALTER SUBSCRIPTION ... REFRESH PUBLICATION之后，对该订阅已知的表。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"ca787c4bb1c8dda60e454d38cee18c218e14475d0650ca16e849513d099854dd","Payload":{"columns":[{"description_zh":"对订阅的引用","name":"srsubid","type":"oid","zh_from":"doc"},{"description_zh":"对关系的引用","name":"srrelid","type":"oid","zh_from":"doc"},{"description_zh":"状态代码：i = 初始化，d = 数据正在被复制，f = 已完成表复制，s = 已同步，r = 就绪（正常复制）","name":"srsubstate","type":"\"char\"","zh_from":"doc"},{"description_zh":"在s或r状态中，用于同步协调的状态更改的远程 LSN，否则为 NULL","name":"srsublsn","type":"pg_lsn","zh_from":"doc"}],"description_zh":"目录pg_subscription_rel包含每个订阅中每个被复制关系的状态。这是一种多对多映射。\n\n此目录只包含在运行CREATE SUBSCRIPTION或ALTER SUBSCRIPTION ... REFRESH PUBLICATION之后，对该订阅已知的表。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}