PostgreSQL Error Reference

Every error, explained

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

3328 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 864 of 3328 errors

22023 ERROR

COPY delimiter and quote must be different — 22023

invalid_parameter_value

PostgreSQL error "COPY delimiter and quote must be different" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

OIDs less than n are reserved for system objects — 22023

invalid_parameter_value

PostgreSQL error "OIDs less than n are reserved for system objects" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid connection limit: n — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

encoding “…” is not supported with ICU provider — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

pg_global cannot be used as default tablespace — 22023

invalid_parameter_value

PostgreSQL error "pg_global cannot be used as default tablespace" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

database OID n is already in use by database “…” — 22023

invalid_parameter_value

PostgreSQL error "database OID n is already in use by database "…"" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

data directory with the specified OID n already exists — 22023

invalid_parameter_value

PostgreSQL error "data directory with the specified OID n already exists" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot disallow connections for current database — 22023

invalid_parameter_value

PostgreSQL error "cannot disallow connections for current database" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
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