P

PostgreSQL PostgreSQL 18

18 · 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.