Expand description
Catalog dependencies as PostgreSQL records them in pg_depend and pg_shdepend, and the deletion search and reports that DROP makes from them.
Structs§
- Cascade
Notice - The
NOTICEa cascadingDROPreports: one line for a single object, or a count with the list in the detail. - Deletion
Flags DEPFLAG_*: how the search reached an object.- Deletion
Target - One object to delete, with how it was reached and the object whose deletion requires it.
- Deletion
Targets - The objects to delete in deletion order: every dependent before the object it depends on.
- Dependency
- Dependency
Graph - Object
Address - The catalog holding an object’s row, the row’s OID, and for a column of a relation its column number; zero names the whole object.
- Shared
Dependency - A dependency of an object on a role or tablespace, which every database shares.
Enums§
- Dependency
Kind pg_depend.deptype.- Shared
Dependency Kind pg_shdepend.deptype.
Constants§
- ATTRIBUTE_
DEFAULT_ CLASS pg_attrdef: column defaults and generation expressions.- CONSTRAINT_
CLASS pg_constraint.- DATABASE_
CLASS pg_database, which every database shares.- FOREIGN_
SERVER_ CLASS pg_foreign_server.- FOREIGN_
WRAPPER_ CLASS pg_foreign_data_wrapper.- LANGUAGE_
CLASS pg_language.- NAMESPACE_
CLASS pg_namespace.- PROCEDURE_
CLASS pg_proc.- RELATION_
CLASS pg_class: relations, and with a column number, their columns.- REWRITE_
CLASS pg_rewrite.- ROLE_
CLASS pg_authid: roles, which every database shares.- ROLE_
MEMBERSHIP_ CLASS pg_auth_members: role memberships, which every database shares.- TRIGGER_
CLASS pg_trigger.- TYPE_
CLASS pg_type.
Functions§
- shared_
dependency_ detail checkSharedDependencies: the detail listing what depends onreferenced, by ascending OID, catalog, column and dependency type;Nonewhen nothing that can be described depends on it. Every row must belong to the current database or be shared.
Type Aliases§
- Describe
getObjectDescription: an object’s description,Nonefor an object that does not exist.