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

22023 ERROR

parameter “…” must be a list of extension names — 22023

invalid_parameter_value

PostgreSQL error "parameter "…" must be a list of extension names" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

extension “…” has no update path from version “…” to version “…” — 22023

invalid_parameter_value

PostgreSQL error "extension "…" has no update path from version "…" to version "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

version to install must be specified — 22023

invalid_parameter_value

PostgreSQL error "version to install must be specified" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

extension “…” has no installation script nor update path for versio… — 22023

invalid_parameter_value

PostgreSQL error "extension "…" has no installation script nor update path for version "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

COST must be positive — 22023

invalid_parameter_value

PostgreSQL error "COST must be positive" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

ROWS must be positive — 22023

invalid_parameter_value

PostgreSQL error "ROWS must be positive" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

ROWS is not applicable when function does not return a set — 22023

invalid_parameter_value

PostgreSQL error "ROWS is not applicable when function does not return a set" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

only shared relations can be placed in pg_global tablespace — 22023

invalid_parameter_value

PostgreSQL error "only shared relations can be placed in pg_global tablespace" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

no security label providers have been loaded — 22023

invalid_parameter_value

PostgreSQL error "no security label providers have been loaded" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

must specify provider when multiple security label providers have b… — 22023

invalid_parameter_value

PostgreSQL error "must specify provider when multiple security label providers have been loaded" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

security label provider “…” is not loaded — 22023

invalid_parameter_value

PostgreSQL error "security label provider "…" is not loaded" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

identity column type must be smallint, integer, or bigint — 22023

invalid_parameter_value

PostgreSQL error "identity column type must be smallint, integer, or bigint" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

INCREMENT must not be zero — 22023

invalid_parameter_value

PostgreSQL error "INCREMENT must not be zero" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

statistics target n is too low — 22023

invalid_parameter_value

PostgreSQL error "statistics target n is too low" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid WAL location (LSN): … — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

skip WAL location (LSN n/n) must be greater than origin LSN n/n — 22023

invalid_parameter_value

PostgreSQL error "skip WAL location (LSN n/n) must be greater than origin LSN n/n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid storage type “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

only tables, indexes, and materialized views exist in tablespaces — 22023

invalid_parameter_value

PostgreSQL error "only tables, indexes, and materialized views exist in tablespaces" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot move relations in to or out of pg_global tablespace — 22023

invalid_parameter_value

PostgreSQL error "cannot move relations in to or out of pg_global tablespace" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid compression method “…” — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

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

invalid_parameter_value

PostgreSQL error "pg_tablespace 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

token type “…” does not exist — 22023

invalid_parameter_value

PostgreSQL error "token type "…" does not exist" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid type category “…”: must be simple ASCII — 22023

invalid_parameter_value

PostgreSQL error "invalid type category "…": must be simple ASCII" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

alignment “…” not recognized — 22023

invalid_parameter_value

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

Data Exception