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 1032 of 3908 errors

22023 ERROR

storage “…” not recognized — 22023

invalid_parameter_value

PostgreSQL error "storage "…" not recognized" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

element type cannot be specified without a subscripting function — 22023

invalid_parameter_value

PostgreSQL error "element type cannot be specified without a subscripting function" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_type array OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_type array OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_type multirange OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_type multirange OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_type multirange array OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_type multirange array OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

pg_authid OID value not set when in binary upgrade mode — 22023

invalid_parameter_value

PostgreSQL error "pg_authid OID value not set when in binary upgrade mode" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot use special role specifier in DROP ROLE — 22023

invalid_parameter_value

PostgreSQL error "cannot use special role specifier in DROP ROLE" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

target type is not an array — 22023

invalid_parameter_value

PostgreSQL error "target type is not an array" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

requested length cannot be negative — 22023

invalid_parameter_value

PostgreSQL error "requested length cannot be negative" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

could not get NID for ASN1_OBJECT object — 22023

invalid_parameter_value

PostgreSQL error "could not get NID for ASN1_OBJECT object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

could not convert NID n to an ASN1_OBJECT structure — 22023

invalid_parameter_value

PostgreSQL error "could not convert NID n to an ASN1_OBJECT structure" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

“…” is not a hash partitioned table — 22023

invalid_parameter_value

PostgreSQL error ""…" is not a hash partitioned table" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

number of partitioning columns (n) does not match number of partiti… — 22023

invalid_parameter_value

PostgreSQL error "number of partitioning columns (n) does not match number of partition keys provided (n)" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

column n of the partition key has type …, but supplied value is of… — 22023

invalid_parameter_value

PostgreSQL error "column n of the partition key has type …, but supplied value is of type …" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

column n of the partition key has type “…”, but supplied value is o… — 22023

invalid_parameter_value

PostgreSQL error "column n of the partition key has type "…", but supplied value is of type "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid target WAL LSN — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

invalid proto_version — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

proto_version “…” out of range — 22023

invalid_parameter_value

PostgreSQL error "proto_version "…" out of range" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

requested proto_version=n does not support streaming, need n or higher — 22023

invalid_parameter_value

PostgreSQL error "requested proto_version=n does not support streaming, need n or higher" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

streaming requested, but not supported by output plugin — 22023

invalid_parameter_value

PostgreSQL error "streaming requested, but not supported by output plugin" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

requested proto_version=n does not support two-phase commit, need n… — 22023

invalid_parameter_value

PostgreSQL error "requested proto_version=n does not support two-phase commit, need n or higher" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

two-phase commit requested, but not supported by output plugin — 22023

invalid_parameter_value

PostgreSQL error "two-phase commit requested, but not supported by output plugin" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

multiple StopWords parameters — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

multiple Language parameters — 22023

invalid_parameter_value

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

Data Exception