PostgreSQL Error Reference

Every error, explained

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

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 936 of 3908 errors

22023 ERROR

multiple recovery targets specified — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

unrecognized default ACL object type “…” — 22023

invalid_parameter_value

PostgreSQL error "unrecognized default ACL object type "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid create database strategy “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

new encoding (…) is incompatible with the encoding of the template… — 22023

invalid_parameter_value

PostgreSQL error "new encoding (…) is incompatible with the encoding of the template database (…)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

new collation (…) is incompatible with the collation of the templat… — 22023

invalid_parameter_value

PostgreSQL error "new collation (…) is incompatible with the collation of the template database (…)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

new LC_CTYPE (…) is incompatible with the LC_CTYPE of the template… — 22023

invalid_parameter_value

PostgreSQL error "new LC_CTYPE (…) is incompatible with the LC_CTYPE of the template database (…)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

new locale provider (…) does not match locale provider of the templ… — 22023

invalid_parameter_value

PostgreSQL error "new locale provider (…) does not match locale provider of the template database (…)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

new ICU locale (…) is incompatible with the ICU locale of the templ… — 22023

invalid_parameter_value

PostgreSQL error "new ICU locale (…) is incompatible with the ICU locale of the template database (…)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

argument list must have even number of elements — 22023

invalid_parameter_value

PostgreSQL error "argument list must have even number of elements" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

flag array element is not a string — 22023

invalid_parameter_value

PostgreSQL error "flag array element is not a string" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

wrong flag in flag array: “…” — 22023

invalid_parameter_value

PostgreSQL error "wrong flag in flag array: "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

log format “…” is not supported — 22023

invalid_parameter_value

PostgreSQL error "log format "…" is not supported" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized reset target: “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

invalid regular expression option: “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

… does not support the “global” option — 22023

invalid_parameter_value

PostgreSQL error "… does not support the "global" option" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unterminated format() type specifier — 22023

invalid_parameter_value

PostgreSQL error "unterminated format() type specifier" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized format() type specifier “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

invalid fork name — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

unsupported format code: n — 22023

invalid_parameter_value

PostgreSQL error "unsupported format code: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

unrecognized parameter namespace “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

invalid option name “…”: must not contain “=” — 22023

invalid_parameter_value

PostgreSQL error "invalid option name "…": must not contain "="" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

parameter “…” specified more than once — 22023

invalid_parameter_value

PostgreSQL error "parameter "…" specified more than once" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid value for boolean option “…”: … — 22023

invalid_parameter_value

PostgreSQL error "invalid value for boolean option "…": …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid value for integer option “…”: … — 22023

invalid_parameter_value

PostgreSQL error "invalid value for integer option "…": …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception