PostgreSQL Error Reference

Every error, explained

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

578 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 168 of 578 errors

22031 ERROR

Invalid Argument For Sql Json Datetime Function — SQLSTATE 22031

invalid_argument_for_sql_json_datetime_function

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

Data Exception
22032 ERROR

Invalid Json Text — SQLSTATE 22032

invalid_json_text

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

Data Exception
22032 ERROR

invalid JSON text — 22032

invalid_json_text

PostgreSQL error "invalid JSON text — 22032" (SQLSTATE 22032): what it means, common causes, and how to fix it.

Data Exception
22033 ERROR

Invalid Sql Json Subscript — SQLSTATE 22033

invalid_sql_json_subscript

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

Data Exception
22034 ERROR

More Than One Sql Json Item — SQLSTATE 22034

more_than_one_sql_json_item

SQLSTATE 22034 (more_than_one_sql_json_item): A value is invalid for its data type or the operation applied to 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
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
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
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
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
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
2203D ERROR

Too Many Json Array Elements — SQLSTATE 2203D

too_many_json_array_elements

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

Data Exception
2203E ERROR

Too Many Json Object Members — SQLSTATE 2203E

too_many_json_object_members

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

Data Exception
2203F ERROR

Sql Json Scalar Required — SQLSTATE 2203F

sql_json_scalar_required

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

Data Exception
2203G ERROR

Sql Json Item Cannot Be Cast To Target Type — SQLSTATE 2203G

sql_json_item_cannot_be_cast_to_target_type

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

Data Exception
22P01 ERROR

Floating Point Exception — SQLSTATE 22P01

floating_point_exception

SQLSTATE 22P01 (floating_point_exception): A value is invalid for its data type or the operation applied to it.

Data Exception
22P02 ERROR

Invalid Text Representation — SQLSTATE 22P02

invalid_text_representation

A text value could not be converted to the requested type.

Data Exception
22P02 ERROR

invalid input syntax for type double precision: “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid input syntax for type double precision: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

invalid input value for enum …: “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid input value for enum …: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

invalid input syntax for type integer: “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid input syntax for type integer: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

invalid input syntax for type boolean: “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid input syntax for type boolean: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

invalid input syntax for type numeric: “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid input syntax for type numeric: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception