PostgreSQL Error Reference

Every error, explained

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

2544 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 912 of 2544 errors

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
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
22P01 ERROR

floating-point exception — 22P01

floating_point_exception

PostgreSQL error "floating-point exception" (SQLSTATE 22P01, floating_point_exception): what it means, common causes, and how to fix 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 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 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
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 uuid: “…” — 22P02

invalid_text_representation

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

Data Exception
22P02 ERROR

invalid input syntax for type json — 22P02

invalid_text_representation

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

Data Exception
22P02 ERROR

malformed array literal: “…” — 22P02

invalid_text_representation

PostgreSQL error "malformed array literal: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

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

invalid_text_representation

PostgreSQL error "invalid input syntax for type inet: "…"" (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

malformed range literal: “…” — 22P02

invalid_text_representation

PostgreSQL error "malformed range literal: "…"" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

array value must start with “{” or dimension information — 22P02

invalid_text_representation

PostgreSQL error "array value must start with "{" or dimension information" (SQLSTATE 22P02): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

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

invalid_text_representation

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

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 syntax for type …: “…” — 22P02

invalid_text_representation

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

Data Exception
22P02 ERROR

invalid character in extension owner: must not contain any of “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid character in extension owner: must not contain any of "…"" (SQLSTATE 22P02, invalid_text_representation): what it means, common causes, and how to fix it.

Data Exception
22P02 ERROR

invalid character in extension “…” schema: must not contain any of “…” — 22P02

invalid_text_representation

PostgreSQL error "invalid character in extension "…" schema: must not contain any of "…"" (SQLSTATE 22P02, invalid_text_representation): what it means, common causes, and how to fix it.

Data Exception