Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 24 of 578 errors
00000
LOG
Successful Completion — SQLSTATE 00000
successful_completion
SQLSTATE 00000 (successful_completion): The operation completed successfully — this is not an error.
01000
WARNING
hot standby is not possible because of insufficient free space in pg_wal — 01000
warning
PostgreSQL error "hot standby is not possible because of insufficient free space in pg_wal — 01000" (SQLSTATE 01000): what it means, common causes, and how to fix it.
01000
WARNING
collation “…” has version mismatch — 01000
warning
PostgreSQL error "collation … has version mismatch — 01000" (SQLSTATE 01000): what it means, common causes, and how to fix it.
01000
WARNING
database must be vacuumed within N transactions — 01000
warning
PostgreSQL error "database must be vacuumed within N transactions — 01000" (SQLSTATE 01000): what it means, common causes, and how to fix it.
01000
WARNING
Warning — SQLSTATE 01000
warning
SQLSTATE 01000 (warning): The statement succeeded but the server attached a warning.
01000
WARNING
subscription was created, but is not connected — 01000
warning
PostgreSQL error "subscription was created, but is not connected — 01000" (SQLSTATE 01000): what it means, common causes, and how to fix it.
01003
WARNING
Null Value Eliminated In Set Function — SQLSTATE 01003
null_value_eliminated_in_set_function
SQLSTATE 01003 (null_value_eliminated_in_set_function): The statement succeeded but the server attached a warning.
01004
WARNING
String Data Right Truncation — SQLSTATE 01004
string_data_right_truncation
SQLSTATE 01004 (string_data_right_truncation): The statement succeeded but the server attached a warning.
01006
WARNING
Privilege Not Revoked — SQLSTATE 01006
privilege_not_revoked
SQLSTATE 01006 (privilege_not_revoked): The statement succeeded but the server attached a warning.
01007
WARNING
Privilege Not Granted — SQLSTATE 01007
privilege_not_granted
SQLSTATE 01007 (privilege_not_granted): The statement succeeded but the server attached a warning.
01008
WARNING
Implicit Zero Bit Padding — SQLSTATE 01008
implicit_zero_bit_padding
SQLSTATE 01008 (implicit_zero_bit_padding): The statement succeeded but the server attached a warning.
0100C
WARNING
Dynamic Result Sets Returned — SQLSTATE 0100C
dynamic_result_sets_returned
SQLSTATE 0100C (dynamic_result_sets_returned): The statement succeeded but the server attached a warning.
01P01
WARNING
Deprecated Feature — SQLSTATE 01P01
deprecated_feature
SQLSTATE 01P01 (deprecated_feature): The statement succeeded but the server attached a warning.
02000
WARNING
No Data — SQLSTATE 02000
no_data
SQLSTATE 02000 (no_data): The statement completed but returned or affected no rows.
02001
WARNING
No Additional Dynamic Result Sets Returned — SQLSTATE 02001
no_additional_dynamic_result_sets_returned
SQLSTATE 02001 (no_additional_dynamic_result_sets_returned): The statement completed but returned or affected no rows.
03000
ERROR
Sql Statement Not Yet Complete — SQLSTATE 03000
sql_statement_not_yet_complete
SQLSTATE 03000 (sql_statement_not_yet_complete): The SQL statement is not yet complete.
08000
ERROR
Connection Exception — SQLSTATE 08000
connection_exception
SQLSTATE 08000 (connection_exception): The client/server connection could not be established or was lost.
08001
ERROR
Sqlclient Unable To Establish Sqlconnection — SQLSTATE 08001
sqlclient_unable_to_establish_sqlconnection
The client could not establish a connection — typically the server is unreachable or not listening for this client.
08001
FATAL
could not connect to server: No such file or directory — 08001
sqlclient_unable_to_establish_sqlconnection
PostgreSQL error "could not connect to server: No such file or directory — 08001" (SQLSTATE 08001): what it means, common causes, and how to fix it.
08003
ERROR
Connection Does Not Exist — SQLSTATE 08003
connection_does_not_exist
The application tried to use a connection that is already closed.
08004
ERROR
Sqlserver Rejected Establishment Of Sqlconnection — SQLSTATE 08004
sqlserver_rejected_establishment_of_sqlconnection
The server actively rejected the connection during startup.
08006
ERROR
could not receive data from server: Connection timed out — 08006
connection_failure
PostgreSQL error "could not receive data from server: Connection timed out" (SQLSTATE 08006): what it means, common causes, and how to fix it.
08006
ERROR
could not connect to server: Connection refused — 08006
connection_failure
PostgreSQL error "could not connect to server: Connection refused" (SQLSTATE 08006): what it means, common causes, and how to fix it.
08006
ERROR
server does not support SSL, but SSL was required — 08006
connection_failure
PostgreSQL error "server does not support SSL, but SSL was required" (SQLSTATE 08006): what it means, common causes, and how to fix it.