dependent_privilege_descriptors_still_exist Dependent Privilege Descriptors Still Exist — SQLSTATE 2B000

The server reports SQLSTATE 2B000 (dependent_privilege_descriptors_still_exist), a condition in the Dependent Privilege Descriptors Still Exist class.

• The error is written to the server log and returned to the client carrying SQLSTATE 2B000.
• Any driver (libpq, JDBC, psycopg, npgsql, pgx) surfaces this code in its error object so you can branch on it programmatically.
• PL/pgSQL can trap it by name: EXCEPTION WHEN dependent_privilege_descriptors_still_exist THEN.

Severity: ERROR  |  PostgreSQL versions: 12, 13, 14, 15, 16, 17

Reproduce with the exact statement and read the full message in the server log (raise log_min_messages / set log_min_error_statement for more context).

2B000 belongs to Class 2B — Dependent Privilege Descriptors Still Exist. In this class, other objects still depend on the target object.

The first two characters (2B) identify the error class, so application code can match the whole class via 2B000 when the specific code is not needed.

Drop or reassign the dependent objects first, or use DROP ... CASCADE once you understand exactly what CASCADE will remove.

Reference: PostgreSQL error codes — Class 2B (Dependent Privilege Descriptors Still Exist).