{"Entry":{"collection":"catalog","key":"pg_shdepend","name":"pg_shdepend","aliases":[],"metadata":{"changed_in":["8.4"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"added","to":"8.1","types":[]},{"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":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":["objsubid"],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","listing":[],"order":false,"removed":[],"status":"changed","to":"8.4","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":"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 SHARED_DEPENDENCY_PIN entry"},{"from":"The OID of the database the dependent object is in, or zero for a shared object","name":"dbid","to":"The OID of the database the dependent object is in, or zero for a shared object or a SHARED_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 SHARED_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 SHARED_DEPENDENCY_PIN entry","name":"classid","to":"The OID of the system catalog the dependent object is in"},{"from":"The OID of the database the dependent object is in, or zero for a shared object or a SHARED_DEPENDENCY_PIN entry","name":"dbid","to":"The OID of the database the dependent object is in, or zero for a shared object"},{"from":"The OID of the specific dependent object, or zero for a SHARED_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":"33ad11a34a24431c5c34690e5db6f68e3f75ee82249be7a6b839841b6feedf72","derived_content_hash":"06437cee187a3862c728361b7cef038f83b1abe74ae6f0084f7af6c475d44154","first_version":"8.1","imported_at":"2026-09-30T00:40:55.822597+08:00","kind":"catalog","last_version":"20","name":"pg_shdepend","position":76,"present_in":["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:115fe90189259b1042415f11503b5f5d55ea5e96625ebe2f19e01e0c05f9b9dd","summary":"The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles.","summary_zh":"目录 pg_shdepend 记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得 PostgreSQL 可以确保对象在尝试删除前未被其他对象引用。"}},"Definition":{"Collection":"catalog","Key":"pg_shdepend","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shdepend","SourceRevision":"catalog-bilingual-repair:115fe90189259b1042415f11503b5f5d55ea5e96625ebe2f19e01e0c05f9b9dd","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the database the dependent object is in, or zero for a shared object","description_zh":"依赖对象所在数据库的 OID，对于共享对象为零","documented":true,"documented_name":"dbid","hidden":false,"name":"dbid","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"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":3,"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":4,"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":5,"description":"The OID of the system catalog the referenced object is in (must be a shared catalog)","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":6,"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":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_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that those objects are unreferenced before attempting to delete them.\n\nSee also pg_depend, which performs a similar function for dependencies involving objects within a single database.\n\nUnlike most system catalogs, pg_shdepend is shared across all databases of a cluster: there is only one copy of pg_shdepend per cluster, not one per database.","description_zh":"目录 pg_shdepend 记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得 PostgreSQL 可以确保对象在尝试删除前未被其他对象引用。\n\n另请参阅 pg_depend，它对单个数据库中对象之间的依赖提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shdepend 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_shdepend 的拷贝，而不是每个数据库一份。","description_zh_html":"\u003cp\u003e目录 pg_shdepend 记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得 PostgreSQL 可以确保对象在尝试删除前未被其他对象引用。\u003c/p\u003e\n\u003cp\u003e另请参阅 pg_depend，它对单个数据库中对象之间的依赖提供了相似的功能。\u003c/p\u003e\n\u003cp\u003e与大部分其他系统目录不同，pg_shdepend 在整个集簇的所有数据库之间共享：在每一个集簇中只有一个 pg_shdepend 的拷贝，而不是每个数据库一份。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.50.6","file":"catalog-pg-shdepend.html","lang":"en","sha256":"26436183c675786b3716962adf333f8975cce4b38e17aa064078b2ca563c1787","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["dbid","classid","objid","objsubid","refclassid","refobjid","deptype"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-shdepend.html","sha256":"89338f5aa6cab330d157bc45e98185063fa4ad1ea1a928f20bb63b43c84b996b","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:09b3608739be7a9c563cb2056181f409e9d60942f4e46aa98f517dab7c316bc2","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.50.6","file":"catalog-pg-shdepend.html","lang":"en","sha256":"26436183c675786b3716962adf333f8975cce4b38e17aa064078b2ca563c1787","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-shdepend.html","sha256":"89338f5aa6cab330d157bc45e98185063fa4ad1ea1a928f20bb63b43c84b996b","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:09b3608739be7a9c563cb2056181f409e9d60942f4e46aa98f517dab7c316bc2","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["dbid","classid","objid","objsubid","refclassid","refobjid","deptype"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_shdepend","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_shdepend","Summary":"The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that those objects are unreferenced before attempting to delete them.\n\nSee also pg_depend, which performs a similar function for dependencies involving objects within a single database.\n\nUnlike most system catalogs, pg_shdepend is shared across all databases of a cluster: there is only one copy of pg_shdepend per cluster, not one per database.","BodyHTML":"\u003cp\u003eThe catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that those objects are unreferenced before attempting to delete them.\n\nSee also pg_depend, which performs a similar function for dependencies involving objects within a single database.\n\nUnlike most system catalogs, pg_shdepend is shared across all databases of a cluster: there is only one copy of pg_shdepend per cluster, not one per database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:115fe90189259b1042415f11503b5f5d55ea5e96625ebe2f19e01e0c05f9b9dd","ContentHash":"5b6992660962d1a09eaeb3d909ef3ef89f5fe32923e6b5e64d8d67117c520d89","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the database the dependent object is in, or zero for a shared object","description_zh":"依赖对象所在数据库的 OID，对于共享对象为零","documented":true,"documented_name":"dbid","hidden":false,"name":"dbid","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"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":3,"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":4,"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":5,"description":"The OID of the system catalog the referenced object is in (must be a shared catalog)","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":6,"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":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_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that those objects are unreferenced before attempting to delete them.\n\nSee also pg_depend, which performs a similar function for dependencies involving objects within a single database.\n\nUnlike most system catalogs, pg_shdepend is shared across all databases of a cluster: there is only one copy of pg_shdepend per cluster, not one per database."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","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}