pqerror

IsClass reports whether an error is of type *pq.Error and has a given class.

IsCode reports whether an error is of type *pq.Error and has a given code.

Class 21 - Cardinality Violation.

Class 20 - Case Not Found.

Class F0 - Configuration File Error.

Class 08 - Connection Exception.

Class 22 - Data Exception.

Class 2B - Dependent Privilege Descriptors Still Exist.

Class 0Z - Diagnostics Exception.

Class 38 - External Routine Exception.

Class 39 - External Routine Invocation Exception.

Class HV - Foreign Data Wrapper Error (SQL/MED).

Class 0A - Feature Not Supported.

Class 53 - Insufficient Resources.

Class 23 - Integrity Constraint Violation.

Class XX - Internal Error.

Class 28 - Invalid Authorization Specification.

Class 3D - Invalid Catalog Name.

Class 34 - Invalid Cursor Name.

Class 24 - Invalid Cursor State.

Class 0L - Invalid Grantor.

Class 0P - Invalid Role Specification.

Class 3F - Invalid Schema Name.

Class 26 - Invalid SQL Statement Name.

Class 0B - Invalid Transaction Initiation.

Class 25 - Invalid Transaction State.

Class 2D - Invalid Transaction Termination.

Class 0F - Locator Exception.

Class 02 - No Data (this is also a warning class per the SQL standard).

Class 55 - Object Not In Prerequisite State.

Class 57 - Operator Intervention.

Class P0 - PL/pgSQL Error.

See https://www.postgresql.org/docs/11/static/errcodes-appendix.html and https://github.com/postgres/postgres/blob/REL_12_STABLE/src/backend/utils/errcodes.txt.

Class 54 - Program Limit Exceeded.

Class 3B - Savepoint Exception.

Class 72 — Snapshot Failure.

Class 2F - SQL Routine Exception.

Class 03 - SQL Statement Not Yet Complete.

Class 00 - Successful Completion.

Class 42 - Syntax Error or Access Rule Violation.

Class 58 - System Error (errors external to PostgreSQL itself).

Class 40 - Transaction Rollback.

Class 09 - Triggered Action Exception.

Class 27 - Triggered Data Change Violation.

Class 01 - Warning.

Class 44 - WITH CHECK OPTION Violation.