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 120 of 578 errors

2200S ERROR

Invalid Xml Comment — SQLSTATE 2200S

invalid_xml_comment

SQLSTATE 2200S (invalid_xml_comment): A value is invalid for its data type or the operation applied to it.

Data Exception
2200T ERROR

Invalid Xml Processing Instruction — SQLSTATE 2200T

invalid_xml_processing_instruction

SQLSTATE 2200T (invalid_xml_processing_instruction): A value is invalid for its data type or the operation applied to it.

Data Exception
22010 ERROR

Invalid Indicator Parameter Value — SQLSTATE 22010

invalid_indicator_parameter_value

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

Data Exception
22011 ERROR

negative substring length not allowed — 22011

substring_error

PostgreSQL error "negative substring length not allowed" (SQLSTATE 22011): what it means, common causes, and how to fix it.

Data Exception
22011 ERROR

Substring Error — SQLSTATE 22011

substring_error

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

Data Exception
22012 ERROR

Division By Zero — SQLSTATE 22012

division_by_zero

A division or modulo operation had a zero divisor.

Data Exception
22012 ERROR

division by zero — 22012

division_by_zero

PostgreSQL error "division by zero" (SQLSTATE 22012): what it means, common causes, and how to fix it.

Data Exception
22013 ERROR

Invalid Preceding Or Following Size — SQLSTATE 22013

invalid_preceding_or_following_size

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

Data Exception
22014 ERROR

Invalid Argument For Ntile Function — SQLSTATE 22014

invalid_argument_for_ntile_function

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

Data Exception
22015 ERROR

Interval Field Overflow — SQLSTATE 22015

interval_field_overflow

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

Data Exception
22015 ERROR

interval out of range — 22015

interval_field_overflow

PostgreSQL error "interval out of range" (SQLSTATE 22015): what it means, common causes, and how to fix it.

Data Exception
22016 ERROR

Invalid Argument For Nth Value Function — SQLSTATE 22016

invalid_argument_for_nth_value_function

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

Data Exception
22018 ERROR

Invalid Character Value For Cast — SQLSTATE 22018

invalid_character_value_for_cast

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

Data Exception
22019 ERROR

Invalid Escape Character — SQLSTATE 22019

invalid_escape_character

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

Data Exception
2201B ERROR

invalid regular expression: … — 2201B

invalid_regular_expression

PostgreSQL error "invalid regular expression: …" (SQLSTATE 2201B): what it means, common causes, and how to fix it.

Data Exception
2201B ERROR

Invalid Regular Expression — SQLSTATE 2201B

invalid_regular_expression

A regular expression pattern is invalid.

Data Exception
2201B ERROR

invalid regular expression: … — 2201B

invalid_regular_expression

PostgreSQL error "invalid regular expression: … — 2201B" (SQLSTATE 2201B): what it means, common causes, and how to fix it.

Data Exception
2201E ERROR

Invalid Argument For Logarithm — SQLSTATE 2201E

invalid_argument_for_logarithm

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

Data Exception
2201E ERROR

cannot take logarithm of a negative number — 2201E

invalid_argument_for_logarithm

PostgreSQL error "cannot take logarithm of a negative number" (SQLSTATE 2201E): what it means, common causes, and how to fix it.

Data Exception
2201E ERROR

cannot take logarithm of zero — 2201E

invalid_argument_for_logarithm

PostgreSQL error "cannot take logarithm of zero" (SQLSTATE 2201E): what it means, common causes, and how to fix it.

Data Exception
2201F ERROR

Invalid Argument For Power Function — SQLSTATE 2201F

invalid_argument_for_power_function

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

Data Exception
2201F ERROR

zero raised to a negative power is undefined — 2201F

invalid_argument_for_power_function

PostgreSQL error "zero raised to a negative power is undefined" (SQLSTATE 2201F): what it means, common causes, and how to fix it.

Data Exception
2201G ERROR

Invalid Argument For Width Bucket Function — SQLSTATE 2201G

invalid_argument_for_width_bucket_function

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

Data Exception
2201W ERROR

Invalid Row Count In Limit Clause — SQLSTATE 2201W

invalid_row_count_in_limit_clause

SQLSTATE 2201W (invalid_row_count_in_limit_clause): A value is invalid for its data type or the operation applied to it.

Data Exception