PostgreSQL SQLSTATE reference — all 50 errors by class · thesev1database

SQLSTATE reference

Every PostgreSQL error, indexed by class

PostgreSQL groups every error code into a two-character class. Below is the full catalog, organized the same way the official manual is — jump to a class, then open any code for the lab-reproduced explanation.

Class 08 · Connection Exception

2 codes

Connection to client lost

Bind message parameter mismatch

Class 0A · Feature Not Supported

1 code

Unique constraint on partitioned table

Class 21 · Cardinality Violation

1 code

More than one row returned by a subquery used as an expression

Class 22 · Data Exception

12 codes

Value too long for character varying(n)

Numeric value out of range

Null value not allowed

Invalid datetime format

Datetime field overflow

Negative substring length not allowed

Division by zero

Invalid regular expression

LIMIT must not be negative

date_trunc invalid field

String data length mismatch

Invalid input syntax

Class 23 · Integrity Constraint Violation

5 codes

Null value in column violates not-null constraint

Insert or update violates foreign key constraint

Duplicate key value violates unique constraint

New row violates check constraint

New row violates exclusion constraint

Class 25 · Invalid Transaction State

6 codes

COPY FREEZE with prior transaction activity

Active SQL transaction

Read-only SQL transaction

No active SQL transaction

Current transaction is aborted, commands ignored until end of transaction block

Idle in transaction session timeout

Class 28 · Invalid Authorization Specification

1 code

Invalid password

Class 2B · Dependent Privilege Descriptors Still Exist

1 code

Dependent objects still exist

Class 34 · Other

1 code

Cursor does not exist

Class 3D · Invalid Catalog Name

1 code

Invalid catalog name

Class 3F · Invalid Schema Name

1 code

Schema does not exist

Class 40 · Transaction Rollback

2 codes

Could not serialize access due to concurrent update

Deadlock detected

Class 42 · Syntax Error or Access Rule Violation

13 codes

Permission denied

Syntax error

Column specified more than once

Column reference is ambiguous

Column does not exist

Duplicate object

UNION types cannot be matched

Cannot coerce

Function does not exist

Cannot insert a non-DEFAULT value into a GENERATED ALWAYS column

Relation does not exist

Undefined parameter

Relation already exists

Class 53 · Insufficient Resources

1 code

Too many connections

Class 54 · Program Limit Exceeded

1 code

Too many function arguments

Class 55 · Object Not In Prerequisite State

3 codes

Object in use

Cannot change runtime parameter

Could not obtain lock on row

Class 57 · Operator Intervention

1 code

Query canceled

Class P0 · PL/pgSQL Error

3 codes

Raise exception

No data found

Too many rows