PostgreSQL PostgreSQL 15
15 · Database Server
40 known error codes for this model
08000
Moderate
PostgreSQL SQLSTATE 08000 (connection_exception) indicates connection exception during connection/session transport handling.
08001
Moderate
PostgreSQL SQLSTATE 08001 (sqlclient_unable_to_establish_sqlconnection) indicates sqlclient unable to establish sqlconnection during connection/session transport handling.
08003
Moderate
PostgreSQL SQLSTATE 08003 (connection_does_not_exist) indicates connection does not exist during connection/session transport handling.
08004
Moderate
PostgreSQL SQLSTATE 08004 (sqlserver_rejected_establishment_of_sqlconnection) indicates sqlserver rejected establishment of sqlconnection during connection/session transport handli…
08006
Moderate
PostgreSQL SQLSTATE 08006 (connection_failure) indicates connection failure during connection/session transport handling.
08P01
Moderate
PostgreSQL SQLSTATE 08P01 (protocol_violation) indicates protocol violation during connection/session transport handling.
0A000
Moderate
PostgreSQL SQLSTATE 0A000 (feature_not_supported) indicates feature not supported during server-side statement validation.
22001
Easy Fix
PostgreSQL SQLSTATE 22001 (string_data_right_truncation) indicates string data right truncation during input value parsing and casting.
22003
Easy Fix
PostgreSQL SQLSTATE 22003 (numeric_value_out_of_range) indicates numeric value out of range during input value parsing and casting.
22004
Easy Fix
PostgreSQL SQLSTATE 22004 (null_value_not_allowed) indicates null value not allowed during input value parsing and casting.
22007
Easy Fix
PostgreSQL SQLSTATE 22007 (invalid_datetime_format) indicates invalid datetime format during input value parsing and casting.
22008
Easy Fix
PostgreSQL SQLSTATE 22008 (datetime_field_overflow) indicates datetime field overflow during input value parsing and casting.
22012
Easy Fix
PostgreSQL SQLSTATE 22012 (division_by_zero) indicates division by zero during input value parsing and casting.
22023
Easy Fix
PostgreSQL SQLSTATE 22023 (invalid_parameter_value) indicates invalid parameter value during input value parsing and casting.
22P02
Easy Fix
PostgreSQL SQLSTATE 22P02 (invalid_text_representation) indicates invalid text representation during input value parsing and casting.
23000
Easy Fix
PostgreSQL SQLSTATE 23000 (integrity_constraint_violation) indicates integrity constraint violation during constraint and relational integrity checks.
23502
Easy Fix
PostgreSQL SQLSTATE 23502 (not_null_violation) indicates not null violation during constraint and relational integrity checks.
23503
Easy Fix
PostgreSQL SQLSTATE 23503 (foreign_key_violation) indicates foreign key violation during constraint and relational integrity checks.
23505
Easy Fix
PostgreSQL SQLSTATE 23505 (unique_violation) indicates unique violation during constraint and relational integrity checks.
23514
Easy Fix
PostgreSQL SQLSTATE 23514 (check_violation) indicates check violation during constraint and relational integrity checks.
23P01
Easy Fix
PostgreSQL SQLSTATE 23P01 (exclusion_violation) indicates exclusion violation during constraint and relational integrity checks.
25006
Moderate
PostgreSQL SQLSTATE 25006 (read_only_sql_transaction) indicates read only sql transaction during transaction lifecycle and lock behavior.
25P01
Moderate
PostgreSQL SQLSTATE 25P01 (no_active_sql_transaction) indicates no active sql transaction during transaction lifecycle and lock behavior.
25P02
Moderate
PostgreSQL SQLSTATE 25P02 (in_failed_sql_transaction) indicates in failed sql transaction during transaction lifecycle and lock behavior.
25P03
Moderate
PostgreSQL SQLSTATE 25P03 (idle_in_transaction_session_timeout) indicates idle in transaction session timeout during transaction lifecycle and lock behavior.
40001
Moderate
PostgreSQL SQLSTATE 40001 (serialization_failure) indicates serialization failure during transaction lifecycle and lock behavior.
40P01
Moderate
PostgreSQL SQLSTATE 40P01 (deadlock_detected) indicates deadlock detected during transaction lifecycle and lock behavior.
42601
Easy Fix
PostgreSQL SQLSTATE 42601 (syntax_error) indicates syntax error during query object resolution and SQL compilation.
42701
Easy Fix
PostgreSQL SQLSTATE 42701 (duplicate_column) indicates duplicate column during query object resolution and SQL compilation.
42703
Easy Fix
PostgreSQL SQLSTATE 42703 (undefined_column) indicates undefined column during query object resolution and SQL compilation.
42704
Easy Fix
PostgreSQL SQLSTATE 42704 (undefined_object) indicates undefined object during query object resolution and SQL compilation.
42803
Easy Fix
PostgreSQL SQLSTATE 42803 (grouping_error) indicates grouping error during query object resolution and SQL compilation.
42804
Easy Fix
PostgreSQL SQLSTATE 42804 (datatype_mismatch) indicates datatype mismatch during query object resolution and SQL compilation.
42830
Easy Fix
PostgreSQL SQLSTATE 42830 (invalid_foreign_key) indicates invalid foreign key during query object resolution and SQL compilation.
42846
Easy Fix
PostgreSQL SQLSTATE 42846 (cannot_coerce) indicates cannot coerce during query object resolution and SQL compilation.
42883
Easy Fix
PostgreSQL SQLSTATE 42883 (undefined_function) indicates undefined function during query object resolution and SQL compilation.
42P01
Easy Fix
PostgreSQL SQLSTATE 42P01 (undefined_table) indicates undefined table during query object resolution and SQL compilation.
42P02
Easy Fix
PostgreSQL SQLSTATE 42P02 (undefined_parameter) indicates undefined parameter during query object resolution and SQL compilation.
42P07
Easy Fix
PostgreSQL SQLSTATE 42P07 (duplicate_table) indicates duplicate table during query object resolution and SQL compilation.
42P10
Easy Fix
PostgreSQL SQLSTATE 42P10 (invalid_column_reference) indicates invalid column reference during query object resolution and SQL compilation.