PostgreSQL Error Codes

SQLSTATE error codes returned by PostgreSQL. Each code is five characters: the first two identify the class, the last three the specific condition.

148 codes

• 00000 Successful completion
• 0A000 Feature not supported
• 0B000 Invalid transaction initiation
• 01P01 Deprecated feature
• 2BP01 Dependent objects still exist
• 2D000 Invalid transaction termination
• 3B001 Invalid savepoint specification
• 3D000 Invalid catalog name
• 3F000 Invalid schema name
• 08P01 Protocol violation
• 22P01 Floating point exception
• 22P02 Invalid text representation
• 22P03 Invalid binary representation
• 22P04 Bad copy file format
• 22P05 Untranslatable character
• 23P01 Exclusion violation
• 25P01 No active SQL transaction
• 25P02 In failed SQL transaction
• 25P03 Idle in transaction session timeout
• 28P01 Invalid password
• 40P01 Deadlock detected
• 42P01 Undefined table
• 42P02 Undefined parameter
• 42P03 Duplicate cursor
• 42P04 Duplicate database
• 42P05 Duplicate prepared statement
• 42P06 Duplicate schema
• 42P07 Duplicate table
• 42P08 Ambiguous parameter
• 42P18 Indeterminate datatype
• 42P20 Windowing error
• 55P02 Cannot change runtime parameter
• 55P03 Lock not available
• 57P01 Admin shutdown
• 57P02 Crash shutdown
• 57P03 Cannot connect now
• 57P04 Database dropped
• 57P05 Idle session timeout
• 58P01 Undefined file
• 58P02 Duplicate file
• 01000 Warning
• 01003 Null value eliminated in set function
• 01004 String data right truncation
• 01006 Privilege not revoked
• 01007 Privilege not granted
• 02000 No data
• 2201B Invalid regular expression
• 2201E Invalid argument for logarithm
• 2201F Invalid argument for power function
• 2202E Array subscript error
• 03000 SQL statement not yet complete
• 08000 Connection exception
• 08001 SQL client unable to establish SQL connection
• 08003 Connection does not exist
• 08004 SQL server rejected establishment of SQL connection
• 08006 Connection failure
• 08007 Transaction resolution unknown
• 09000 Triggered action exception
• 20000 Case not found
• 21000 Cardinality violation
• 22000 Data exception
• 22001 String data right truncation
• 22002 Null value, no indicator parameter
• 22003 Numeric value out of range
• 22004 Null value not allowed
• 22005 Error in assignment
• 22007 Invalid datetime format
• 22008 Datetime field overflow
• 22009 Invalid time zone displacement value
• 22012 Division by zero
• 22015 Interval field overflow
• 22018 Invalid character value for cast
• 22019 Invalid escape character
• 22021 Character not in repertoire
• 22022 Indicator overflow
• 22023 Invalid parameter value
• 22024 Unterminated C string
• 22025 Invalid escape sequence
• 22026 String data length mismatch
• 22032 Invalid JSON text
• 22034 More than one SQL/JSON item
• 22035 No SQL/JSON item
• 23000 Integrity constraint violation
• 23001 Restrict violation
• 23502 Not null violation
• 23503 Foreign key violation
• 23505 Unique violation
• 23514 Check violation
• 24000 Invalid cursor state
• 25000 Invalid transaction state
• 25001 Active SQL transaction
• 25006 Read only SQL transaction
• 26000 Invalid SQL statement name
• 27000 Triggered data change violation
• 28000 Invalid authorization specification
• 34000 Invalid cursor name
• 40000 Transaction rollback
• 40001 Serialization failure
• 40002 Transaction integrity constraint violation
• 40003 Statement completion unknown
• 42000 Syntax error or access rule violation
• 42501 Insufficient privilege
• 42601 Syntax error
• 42602 Invalid name
• 42611 Invalid column definition
• 42622 Name too long
• 42701 Duplicate column
• 42702 Ambiguous column
• 42703 Undefined column
• 42704 Undefined object
• 42710 Duplicate object
• 42712 Duplicate alias
• 42723 Duplicate function
• 42725 Ambiguous function
• 42803 Grouping error
• 42804 Datatype mismatch
• 42809 Wrong object type
• 42830 Invalid foreign key
• 42846 Cannot coerce
• 42883 Undefined function
• 42939 Reserved name
• 44000 WITH CHECK OPTION violation
• 53000 Insufficient resources
• 53100 Disk full
• 53200 Out of memory
• 53300 Too many connections
• 53400 Configuration limit exceeded
• 54000 Program limit exceeded
• 54001 Statement too complex
• 54011 Too many columns
• 54023 Too many arguments
• 55000 Object not in prerequisite state
• 55006 Object in use
• 57000 Operator intervention
• 57014 Query cancelled
• 58000 System error
• 58030 IO error
• 72000 Snapshot too old
• F0000 Config file error
• F0001 Lock file exists
• P0000 PL/pgSQL error
• P0001 Raise exception
• P0002 No data found
• P0003 Too many rows
• P0004 Assert failure
• XX000 Internal error
• XX001 Data corrupted
• XX002 Index corrupted