{"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":"c6559d05fbf784aca43e0dd61ddaaa05b6fc8dc9c1b2136a54784c6d678660be","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":"english-manuals:09b3608739be7a9c563cb2056181f409e9d60942f4e46aa98f517dab7c316bc2","summary":"The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_shdepend","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shdepend","SourceRevision":"english-manuals:09b3608739be7a9c563cb2056181f409e9d60942f4e46aa98f517dab7c316bc2","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":"","documented":true,"documented_name":"dbid","hidden":false,"name":"dbid","not_null":true,"references":"pg_database.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog the dependent object is in","description_zh":"","documented":true,"documented_name":"classid","hidden":false,"name":"classid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"The OID of the specific dependent object","description_zh":"","documented":true,"documented_name":"objid","hidden":false,"name":"objid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"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":"","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":5,"description":"The OID of the system catalog the referenced object is in (must be a shared catalog)","description_zh":"","documented":true,"documented_name":"refclassid","hidden":false,"name":"refclassid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"The OID of the specific referenced object","description_zh":"","documented":true,"documented_name":"refobjid","hidden":false,"name":"refobjid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"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}],"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":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.50.6","file":"catalog-pg-shdepend.html","lang":"en","sha256":"26436183c675786b3716962adf333f8975cce4b38e17aa064078b2ca563c1787","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_shdepend","Summary":"目录pg_shdepend记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得PostgreSQL可以确保对象在尝试删除前未被其他对象引用。\n\n另请参阅pg_depend，它对单个数据库中对象之间的依赖提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shdepend在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shdepend的拷贝，而不是每个数据库一份。","BodyHTML":"\u003cp\u003e目录pg_shdepend记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得PostgreSQL可以确保对象在尝试删除前未被其他对象引用。\n\n另请参阅pg_depend，它对单个数据库中对象之间的依赖提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shdepend在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shdepend的拷贝，而不是每个数据库一份。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"da3ff729c479aba48be772ae09328f6c52fd205db73694fe50f1560c3ecd4967","Payload":{"columns":[{"description_zh":"依赖对象所在数据库的OID，对于共享对象为零","name":"dbid","type":"oid","zh_from":"doc"},{"description_zh":"依赖对象所在系统目录的OID","name":"classid","type":"oid","zh_from":"doc"},{"description_zh":"特定依赖对象的OID","name":"objid","type":"oid","zh_from":"doc"},{"description_zh":"对于一个表列，这里是列号（objid和classid指表本身）。对于所有其他对象类型，此列为0。","name":"objsubid","type":"integer","zh_from":"doc"},{"description_zh":"被引用对象所在的系统目录的OID（必须是一个共享的目录）","name":"refclassid","type":"oid","zh_from":"doc"},{"description_zh":"指定被引用对象的OID","name":"refobjid","type":"oid","zh_from":"doc"},{"description_zh":"定义此依赖关系语义的一个代码，见下文","name":"deptype","type":"\"char\"","zh_from":"doc"}],"description_zh":"目录pg_shdepend记录数据库对象与共享对象（例如角色）之间的依赖关系。这些信息使得PostgreSQL可以确保对象在尝试删除前未被其他对象引用。\n\n另请参阅pg_depend，它对单个数据库中对象之间的依赖提供了相似的功能。\n\n与大部分其他系统目录不同，pg_shdepend在整个集簇的所有数据库之间共享：在每一个集簇中只有一个pg_shdepend的拷贝，而不是每个数据库一份。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}