{"Entry":{"collection":"catalog","key":"pg_inherits","name":"pg_inherits","aliases":[],"metadata":{"changed_in":["14"],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"If there is more than one parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.","name":"inhseqno","to":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1."}],"from":"7.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the parent table.","name":"inhparent","to":"The OID of the parent table"},{"from":"The OID of the child table.","name":"inhrelid","to":"The OID of the child table"},{"from":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.","name":"inhseqno","to":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1","name":"inhseqno","to":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"The OID of the parent table","name":"inhparent","to":"The OID of the parent table or index"},{"from":"The OID of the child table","name":"inhrelid","to":"The OID of the child table or index"},{"from":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.","name":"inhseqno","to":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1. Indexes can not have multiple inheritance, since they can only inherit when using declarative partitioning."}],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1. Indexes can not have multiple inheritance, since they can only inherit when using declarative partitioning.","name":"inhseqno","to":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.\n\nIndexes cannot have multiple inheritance, since they can only inherit when using declarative partitioning."}],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":["inhdetachpending"],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"changed","to":"14","types":[],"unlisted":[]}],"column_count":4,"content_hash":"744e3c423b31f7a5a4daeca3e14fe165059eb32079401f0ce8facd8f531b8f29","first_version":"7.4","imported_at":"2026-09-30T00:40:55.583119+08:00","kind":"catalog","last_version":"20","name":"pg_inherits","position":38,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:8960c6d156409eada07caa929fdd82b2ed03a1709efc4021507953a7872b6df1","summary":"The catalog pg_inherits records information about table and index inheritance hierarchies.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_inherits","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_inherits","SourceRevision":"english-manuals:8960c6d156409eada07caa929fdd82b2ed03a1709efc4021507953a7872b6df1","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the child table or index","description_zh":"","documented":true,"documented_name":"inhrelid","hidden":false,"name":"inhrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the parent table or index","description_zh":"","documented":true,"documented_name":"inhparent","hidden":false,"name":"inhparent","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"If there is more than one direct parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1.\n\nIndexes cannot have multiple inheritance, since they can only inherit when using declarative partitioning.","description_zh":"","documented":true,"documented_name":"inhseqno","hidden":false,"name":"inhseqno","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"true for a partition that is in the process of being detached; false otherwise.","description_zh":"","documented":true,"documented_name":"inhdetachpending","hidden":false,"name":"inhdetachpending","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16}],"description":"The catalog pg_inherits records information about table and index inheritance hierarchies. There is one entry for each direct parent-child table or index relationship in the database. (Indirect inheritance can be determined by following chains of entries.)","description_zh":"","doc":{"anchor":"id-1.10.4.29.4","file":"catalog-pg-inherits.html","lang":"en","sha256":"bfa3556ebfc1daff1838b40a79c81fc9242c6b9cbee0bde4f09922f8cda0aa9e","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["inhrelid","inhparent","inhseqno","inhdetachpending"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.29.4","file":"catalog-pg-inherits.html","lang":"en","sha256":"bfa3556ebfc1daff1838b40a79c81fc9242c6b9cbee0bde4f09922f8cda0aa9e","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["inhrelid","inhparent","inhseqno","inhdetachpending"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_inherits","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_inherits","Summary":"目录pg_inherits记录有关表和索引的继承层次的信息。数据库中每个表或索引的直接父子关系在这里都有一项（非直接继承可以通过顺着项构成的链来决定）。","BodyHTML":"\u003cp\u003e目录pg_inherits记录有关表和索引的继承层次的信息。数据库中每个表或索引的直接父子关系在这里都有一项（非直接继承可以通过顺着项构成的链来决定）。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"851860960983bf070be2d62a774123d4990f0385376731e295a16a328f7348e9","Payload":{"columns":[{"description_zh":"子表或索引的OID","name":"inhrelid","type":"oid","zh_from":"doc"},{"description_zh":"父表或索引的OID","name":"inhparent","type":"oid","zh_from":"doc"},{"description_zh":"如果子表有多个直接父表（多重继承），此编号指示应当如何排列继承列的顺序。编号从 1 开始。\n\n索引不能多重继承，因为索引只有在使用声明式分区时才能继承。","name":"inhseqno","type":"integer","zh_from":"doc"},{"description_zh":"对于正在分离的分区，此值为 true；否则为 false。","name":"inhdetachpending","type":"boolean","zh_from":"doc"}],"description_zh":"目录pg_inherits记录有关表和索引的继承层次的信息。数据库中每个表或索引的直接父子关系在这里都有一项（非直接继承可以通过顺着项构成的链来决定）。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}
