PostgreSQL error codes
27 codes — tap one for its meaning, causes, and fix steps.
- 08001sqlclient_unable_to_establish_sqlconnection — initial connection refused
- 08006connection_failure — the connection to the server broke
- 0A000feature_not_supported — the requested feature is not implemented
- 22001string_data_right_truncation — a value is too long for the column
- 22003numeric_value_out_of_range — a number exceeds the column's storage range
- 22P02invalid_text_representation — a string could not be parsed into the target type
- 23502not_null_violation — a required column received no value
- 23503foreign_key_violation — the referenced row does not exist
- 23505unique_violation — a row with this key already exists
- 23514check_violation — a row failed a table check constraint
- 25P02in_failed_sql_transaction — the current transaction has already failed
- 28000invalid_authorization_specification — the role is not permitted to connect
- 28P01invalid_password — authentication failed due to a wrong password
- 3D000invalid_catalog_name — the named database does not exist
- 40001serialization_failure — the transaction conflicted with a concurrent write
- 40P01deadlock_detected — two transactions are waiting on each other
- 42601syntax_error — the SQL statement has a syntax mistake
- 42703undefined_column — the column does not exist in this table
- 42883undefined_function — no function matches the call signature
- 42P01undefined_table — the named table does not exist
- 42P07duplicate_table — a table with this name already exists
- 53100disk_full — the server ran out of disk space
- 53300too_many_connections — all connection slots are taken
- 54000program_limit_exceeded — a hard internal limit was hit
- 55P03lock_not_available — a required lock could not be acquired immediately
- 57014query_canceled — the query was explicitly canceled
- 57P01admin_shutdown — the server is shutting down