PostgreSQL Error Reference

Every error, explained

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

3304 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 936 of 3304 errors

22023 ERROR

cannot call … on a scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot call … on a scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot call … on an array — 22023

invalid_parameter_value

PostgreSQL error "cannot call … on an array" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot get array length of a scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot get array length of a scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot get array length of a non-array — 22023

invalid_parameter_value

PostgreSQL error "cannot get array length of a non-array" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot call … on a non-object — 22023

invalid_parameter_value

PostgreSQL error "cannot call … on a non-object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot deconstruct an array as an object — 22023

invalid_parameter_value

PostgreSQL error "cannot deconstruct an array as an object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot deconstruct a scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot deconstruct a scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot extract elements from an object — 22023

invalid_parameter_value

PostgreSQL error "cannot extract elements from an object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot call … on a non-array — 22023

invalid_parameter_value

PostgreSQL error "cannot call … on a non-array" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

argument of … must be an array of objects — 22023

invalid_parameter_value

PostgreSQL error "argument of … must be an array of objects" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot call … on an object — 22023

invalid_parameter_value

PostgreSQL error "cannot call … on an object" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot delete from scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot delete from scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot delete from object using integer index — 22023

invalid_parameter_value

PostgreSQL error "cannot delete from object using integer index" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot set path in scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot set path in scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot delete path in scalar — 22023

invalid_parameter_value

PostgreSQL error "cannot delete path in scalar" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

path element at position n is out of range: n — 22023

invalid_parameter_value

PostgreSQL error "path element at position n is out of range: n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

wrong flag type, only arrays and scalars are allowed — 22023

invalid_parameter_value

PostgreSQL error "wrong flag type, only arrays and scalars are allowed" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

levenshtein argument exceeds maximum length of n characters — 22023

invalid_parameter_value

PostgreSQL error "levenshtein argument exceeds maximum length of n characters" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

invalid mask length: n — 22023

invalid_parameter_value

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

Data Exception
22023 ERROR

cannot merge addresses from different families — 22023

invalid_parameter_value

PostgreSQL error "cannot merge addresses from different families" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot AND inet values of different sizes — 22023

invalid_parameter_value

PostgreSQL error "cannot AND inet values of different sizes" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot OR inet values of different sizes — 22023

invalid_parameter_value

PostgreSQL error "cannot OR inet values of different sizes" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

cannot subtract inet values of different sizes — 22023

invalid_parameter_value

PostgreSQL error "cannot subtract inet values of different sizes" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception
22023 ERROR

NUMERIC precision n must be between 1 and n — 22023

invalid_parameter_value

PostgreSQL error "NUMERIC precision n must be between 1 and n" (SQLSTATE 22023, invalid_parameter_value): what it means, common causes, and how to fix it.

Data Exception