PostgreSQL Error Reference

Every error, explained

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

2697 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 936 of 2697 errors

22034 ERROR

JSON path expression for column “…” must return single item when no… — 22034

more_than_one_sql_json_item

PostgreSQL error "JSON path expression for column "…" must return single item when no wrapper is requested" (SQLSTATE 22034, more_than_one_sql_json_item): what it means, common causes, and how to fix it.

Data Exception
22035 ERROR

No Sql Json Item — SQLSTATE 22035

no_sql_json_item

SQLSTATE 22035 (no_sql_json_item): A value is invalid for its data type or the operation applied to it.

Data Exception
22036 ERROR

Non Numeric Sql Json Item — SQLSTATE 22036

non_numeric_sql_json_item

SQLSTATE 22036 (non_numeric_sql_json_item): A value is invalid for its data type or the operation applied to it.

Data Exception
22036 ERROR

jsonpath item method .…() can only be applied to a string or numeri… — 22036

non_numeric_sql_json_item

PostgreSQL error "jsonpath item method .…() can only be applied to a string or numeric value" (SQLSTATE 22036, non_numeric_sql_json_item): what it means, common causes, and how to fix it.

Data Exception
22036 ERROR

jsonpath item method .…() can only be applied to a numeric value — 22036

non_numeric_sql_json_item

PostgreSQL error "jsonpath item method .…() can only be applied to a numeric value" (SQLSTATE 22036, non_numeric_sql_json_item): what it means, common causes, and how to fix it.

Data Exception
22036 ERROR

numeric argument of jsonpath item method .…() is out of range for t… — 22036

non_numeric_sql_json_item

PostgreSQL error "numeric argument of jsonpath item method .…() is out of range for type double precision" (SQLSTATE 22036, non_numeric_sql_json_item): what it means, common causes, and how to fix it.

Data Exception
22036 ERROR

string argument of jsonpath item method .…() is not a valid represe… — 22036

non_numeric_sql_json_item

PostgreSQL error "string argument of jsonpath item method .…() is not a valid representation of a double precision number" (SQLSTATE 22036, non_numeric_sql_json_item): what it means, common causes, and how to fix it.

Data Exception
22037 ERROR

Non Unique Keys In A Json Object — SQLSTATE 22037

non_unique_keys_in_a_json_object

SQLSTATE 22037 (non_unique_keys_in_a_json_object): A value is invalid for its data type or the operation applied to it.

Data Exception
22038 ERROR

Singleton Sql Json Item Required — SQLSTATE 22038

singleton_sql_json_item_required

SQLSTATE 22038 (singleton_sql_json_item_required): A value is invalid for its data type or the operation applied to it.

Data Exception
22038 ERROR

single boolean result is expected — 22038

singleton_sql_json_item_required

PostgreSQL error "single boolean result is expected" (SQLSTATE 22038, singleton_sql_json_item_required): what it means, common causes, and how to fix it.

Data Exception
22038 ERROR

left operand of jsonpath operator … is not a single numeric value — 22038

singleton_sql_json_item_required

PostgreSQL error "left operand of jsonpath operator … is not a single numeric value" (SQLSTATE 22038, singleton_sql_json_item_required): what it means, common causes, and how to fix it.

Data Exception
22038 ERROR

right operand of jsonpath operator … is not a single numeric value — 22038

singleton_sql_json_item_required

PostgreSQL error "right operand of jsonpath operator … is not a single numeric value" (SQLSTATE 22038, singleton_sql_json_item_required): what it means, common causes, and how to fix it.

Data Exception
22039 ERROR

Sql Json Array Not Found — SQLSTATE 22039

sql_json_array_not_found

SQLSTATE 22039 (sql_json_array_not_found): A value is invalid for its data type or the operation applied to it.

Data Exception
22039 ERROR

jsonpath wildcard array accessor can only be applied to an array — 22039

sql_json_array_not_found

PostgreSQL error "jsonpath wildcard array accessor can only be applied to an array" (SQLSTATE 22039, sql_json_array_not_found): what it means, common causes, and how to fix it.

Data Exception
22039 ERROR

jsonpath array accessor can only be applied to an array — 22039

sql_json_array_not_found

PostgreSQL error "jsonpath array accessor can only be applied to an array" (SQLSTATE 22039, sql_json_array_not_found): what it means, common causes, and how to fix it.

Data Exception
22039 ERROR

jsonpath item method .…() can only be applied to an array — 22039

sql_json_array_not_found

PostgreSQL error "jsonpath item method .…() can only be applied to an array" (SQLSTATE 22039, sql_json_array_not_found): what it means, common causes, and how to fix it.

Data Exception
2203A ERROR

Sql Json Member Not Found — SQLSTATE 2203A

sql_json_member_not_found

SQLSTATE 2203A (sql_json_member_not_found): A value is invalid for its data type or the operation applied to it.

Data Exception
2203A ERROR

JSON object does not contain key “…” — 2203A

sql_json_member_not_found

PostgreSQL error "JSON object does not contain key "…"" (SQLSTATE 2203A, sql_json_member_not_found): what it means, common causes, and how to fix it.

Data Exception
2203A ERROR

jsonpath member accessor can only be applied to an object — 2203A

sql_json_member_not_found

PostgreSQL error "jsonpath member accessor can only be applied to an object" (SQLSTATE 2203A, sql_json_member_not_found): what it means, common causes, and how to fix it.

Data Exception
2203B ERROR

Sql Json Number Not Found — SQLSTATE 2203B

sql_json_number_not_found

SQLSTATE 2203B (sql_json_number_not_found): A value is invalid for its data type or the operation applied to it.

Data Exception
2203B ERROR

operand of unary jsonpath operator … is not a numeric value — 2203B

sql_json_number_not_found

PostgreSQL error "operand of unary jsonpath operator … is not a numeric value" (SQLSTATE 2203B, sql_json_number_not_found): what it means, common causes, and how to fix it.

Data Exception
2203C ERROR

Sql Json Object Not Found — SQLSTATE 2203C

sql_json_object_not_found

SQLSTATE 2203C (sql_json_object_not_found): A value is invalid for its data type or the operation applied to it.

Data Exception
2203C ERROR

jsonpath wildcard member accessor can only be applied to an object — 2203C

sql_json_object_not_found

PostgreSQL error "jsonpath wildcard member accessor can only be applied to an object" (SQLSTATE 2203C, sql_json_object_not_found): what it means, common causes, and how to fix it.

Data Exception
2203C ERROR

jsonpath item method .…() can only be applied to an object — 2203C

sql_json_object_not_found

PostgreSQL error "jsonpath item method .…() can only be applied to an object" (SQLSTATE 2203C, sql_json_object_not_found): what it means, common causes, and how to fix it.

Data Exception