PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3526 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 960 of 3526 errors

22023 ERROR

missing Language parameter — 22023

invalid_parameter_value

PostgreSQL error "missing Language parameter" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid flags for opening a large object: n — 22023

invalid_parameter_value

PostgreSQL error "invalid flags for opening a large object: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid whence setting: n — 22023

invalid_parameter_value

PostgreSQL error "invalid whence setting: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid large object seek target: — 22023

invalid_parameter_value

PostgreSQL error "invalid large object seek target:" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid large object write request size: n — 22023

invalid_parameter_value

PostgreSQL error "invalid large object write request size: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid large object truncation target: — 22023

invalid_parameter_value

PostgreSQL error "invalid large object truncation target:" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 FATAL

…: no database nor user name specified — 22023

invalid_parameter_value

PostgreSQL error "…: no database nor user name specified" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

multiple DictFile parameters — 22023

invalid_parameter_value

PostgreSQL error "multiple DictFile parameters" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

multiple AffFile parameters — 22023

invalid_parameter_value

PostgreSQL error "multiple AffFile parameters" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized Ispell parameter: “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized Ispell parameter: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

missing AffFile parameter — 22023

invalid_parameter_value

PostgreSQL error "missing AffFile parameter" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

missing DictFile parameter — 22023

invalid_parameter_value

PostgreSQL error "missing DictFile parameter" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

multiple Accept parameters — 22023

invalid_parameter_value

PostgreSQL error "multiple Accept parameters" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized simple dictionary parameter: “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized simple dictionary parameter: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized synonym parameter: “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized synonym parameter: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

missing Synonyms parameter — 22023

invalid_parameter_value

PostgreSQL error "missing Synonyms parameter" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

multiple Dictionary parameters — 22023

invalid_parameter_value

PostgreSQL error "multiple Dictionary parameters" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized Thesaurus parameter: “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized Thesaurus parameter: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

missing Dictionary parameter — 22023

invalid_parameter_value

PostgreSQL error "missing Dictionary parameter" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid text search configuration file name “…” — 22023

invalid_parameter_value

PostgreSQL error "invalid text search configuration file name "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized headline parameter: “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized headline parameter: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

value for “…” is too long — 22023

invalid_parameter_value

PostgreSQL error "value for "…" is too long" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid statistics kind: “…” — 22023

invalid_parameter_value

PostgreSQL error "invalid statistics kind: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

ACL array contains wrong data type — 22023

invalid_parameter_value

PostgreSQL error "ACL array contains wrong data type" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception