{"Entry":{"collection":"catalog","key":"pg_depend","name":"pg_depend","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.0","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.1","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"A code defining the specific semantics of this dependency relationship; see text.","name":"deptype","to":"A code defining the specific semantics of this dependency relationship; see text"},{"from":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.","name":"objsubid","to":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero"},{"from":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.","name":"refobjsubid","to":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero","name":"objsubid","to":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero."},{"from":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero","name":"refobjsubid","to":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the system catalog the dependent object is in","name":"classid","to":"The OID of the system catalog the dependent object is in, or zero for a DEPENDENCY_PIN entry"},{"from":"The OID of the specific dependent object","name":"objid","to":"The OID of the specific dependent object, or zero for a DEPENDENCY_PIN entry"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the system catalog the dependent object is in, or zero for a DEPENDENCY_PIN entry","name":"classid","to":"The OID of the system catalog the dependent object is in"},{"from":"The OID of the specific dependent object, or zero for a DEPENDENCY_PIN entry","name":"objid","to":"The OID of the specific dependent object"}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]}],"column_count":7,"content_hash":"5c831d8e570818e0c5576005f71a108812f6d4ff8b80414322af9f57ffaae860","derived_content_hash":"d0f29b40d688afd507adc1288ec08e512624aa1938d03cf81c2dab045c5bbd71","first_version":"7.4","imported_at":"2026-09-30T00:40:55.507642+08:00","kind":"catalog","last_version":"20","name":"pg_depend","position":23,"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":"catalog-bilingual-repair:639488c679d0fc25d88fbb3f821a31e702307187449e8c2276a8f9eaf8147474","summary":"The catalog pg_depend records the dependency relationships between database objects.","summary_zh":"目录 pg_depend 记录数据库对象之间的依赖关系。这些信息允许 DROP 命令查找必须被 DROP CASCADE 删除的其他对象，或者在 DROP RESTRICT 情况下阻止删除。"}},"Definition":{"Collection":"catalog","Key":"pg_depend","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_depend","SourceRevision":"catalog-bilingual-repair:639488c679d0fc25d88fbb3f821a31e702307187449e8c2276a8f9eaf8147474","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the system catalog the dependent object is in","description_zh":"依赖对象所在系统目录的 OID","documented":true,"documented_name":"classid","hidden":false,"name":"classid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the specific dependent object","description_zh":"特定依赖对象的 OID","documented":true,"documented_name":"objid","hidden":false,"name":"objid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列号（objid 和 classid 指表本身）。对于所有其他对象类型，此列为 0。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The OID of the system catalog the referenced object is in","description_zh":"被引用对象所在的系统目录的 OID","documented":true,"documented_name":"refclassid","hidden":false,"name":"refclassid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The OID of the specific referenced object","description_zh":"指定被引用对象的 OID","documented":true,"documented_name":"refobjid","hidden":false,"name":"refobjid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列号（refobjid 和 refclassid 指表本身）。对于所有其他对象类型，此列为 0。","documented":true,"documented_name":"refobjsubid","hidden":false,"name":"refobjsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"A code defining the specific semantics of this dependency relationship; see text","description_zh":"定义此依赖关系语义的一个代码，见下文","documented":true,"documented_name":"deptype","hidden":false,"name":"deptype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"}],"description":"The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case.\n\nSee also pg_shdepend, which performs a similar function for dependencies involving objects that are shared across a database cluster.","description_zh":"目录 pg_depend 记录数据库对象之间的依赖关系。这些信息允许 DROP 命令查找必须被 DROP CASCADE 删除的其他对象，或者在 DROP RESTRICT 情况下阻止删除。\n\n另请参阅 pg_shdepend，它对涉及数据库集簇共享对象的依赖提供了相似的功能。","description_zh_html":"\u003cp\u003e目录 pg_depend 记录数据库对象之间的依赖关系。这些信息允许 DROP 命令查找必须被 DROP CASCADE 删除的其他对象，或者在 DROP RESTRICT 情况下阻止删除。\u003c/p\u003e\n\u003cp\u003e另请参阅 pg_shdepend，它对涉及数据库集簇共享对象的依赖提供了相似的功能。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.20.5","file":"catalog-pg-depend.html","lang":"en","sha256":"d982ceb8ada0c33d728c3de698cd7e9dfa6b7c8111962436fa4f589e59779957","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["classid","objid","objsubid","refclassid","refobjid","refobjsubid","deptype"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-depend.html","sha256":"8d8b66b1ab82780b564d1600241f44491f30d0229f63c76d3a09b32167d43a74","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:71953b694f236deae10e284631f935d8ab1de7ebf1e04f048c468177c4309d95","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.20.5","file":"catalog-pg-depend.html","lang":"en","sha256":"d982ceb8ada0c33d728c3de698cd7e9dfa6b7c8111962436fa4f589e59779957","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-depend.html","sha256":"8d8b66b1ab82780b564d1600241f44491f30d0229f63c76d3a09b32167d43a74","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:71953b694f236deae10e284631f935d8ab1de7ebf1e04f048c468177c4309d95","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["classid","objid","objsubid","refclassid","refobjid","refobjsubid","deptype"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_depend","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_depend","Summary":"The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case.\n\nSee also pg_shdepend, which performs a similar function for dependencies involving objects that are shared across a database cluster.","BodyHTML":"\u003cp\u003eThe catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case.\n\nSee also pg_shdepend, which performs a similar function for dependencies involving objects that are shared across a database cluster.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:639488c679d0fc25d88fbb3f821a31e702307187449e8c2276a8f9eaf8147474","ContentHash":"1b5683b4cd5a4de5f0cfa2d15eb5f991e981c433adb8425f95d90e4c6b4d39b2","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the system catalog the dependent object is in","description_zh":"依赖对象所在系统目录的 OID","documented":true,"documented_name":"classid","hidden":false,"name":"classid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The OID of the specific dependent object","description_zh":"特定依赖对象的 OID","documented":true,"documented_name":"objid","hidden":false,"name":"objid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"For a table column, this is the column number (the objid and classid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列号（objid 和 classid 指表本身）。对于所有其他对象类型，此列为 0。","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The OID of the system catalog the referenced object is in","description_zh":"被引用对象所在的系统目录的 OID","documented":true,"documented_name":"refclassid","hidden":false,"name":"refclassid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The OID of the specific referenced object","description_zh":"指定被引用对象的 OID","documented":true,"documented_name":"refobjid","hidden":false,"name":"refobjid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"For a table column, this is the column number (the refobjid and refclassid refer to the table itself). For all other object types, this column is zero.","description_zh":"对于一个表列，这里是列号（refobjid 和 refclassid 指表本身）。对于所有其他对象类型，此列为 0。","documented":true,"documented_name":"refobjsubid","hidden":false,"name":"refobjsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"A code defining the specific semantics of this dependency relationship; see text","description_zh":"定义此依赖关系语义的一个代码，见下文","documented":true,"documented_name":"deptype","hidden":false,"name":"deptype","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"}],"description":"The catalog pg_depend records the dependency relationships between database objects. This information allows DROP commands to find which other objects must be dropped by DROP CASCADE or prevent dropping in the DROP RESTRICT case.\n\nSee also pg_shdepend, which performs a similar function for dependencies involving objects that are shared across a database cluster."}},"RequestedLocale":"en","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}