Every error, explained

2200S ERROR

invalid XML comment — 2200S

invalid_xml_comment

PostgreSQL error "invalid XML comment" (SQLSTATE 2200S, invalid_xml_comment): what it means, common causes, and how to fix it.

Data Exception arrow_forward

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 arrow_forward

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 arrow_forward

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 arrow_forward

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 arrow_forward

22012 ERROR

Division By Zero — SQLSTATE 22012

division_by_zero

A division or modulo operation had a zero divisor.

Data Exception arrow_forward

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 arrow_forward

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 arrow_forward

22013 ERROR

frame starting offset must not be negative — 22013

invalid_preceding_or_following_size

PostgreSQL error "frame starting offset must not be negative" (SQLSTATE 22013, invalid_preceding_or_following_size): what it means, common causes, and how to fix it.

Data Exception arrow_forward

22013 ERROR

frame ending offset must not be negative — 22013

invalid_preceding_or_following_size

PostgreSQL error "frame ending offset must not be negative" (SQLSTATE 22013, invalid_preceding_or_following_size): what it means, common causes, and how to fix it.

Data Exception arrow_forward

22013 ERROR

invalid preceding or following size in window function — 22013

invalid_preceding_or_following_size

PostgreSQL error "invalid preceding or following size in window function" (SQLSTATE 22013, invalid_preceding_or_following_size): what it means, common causes, and how to fix it.

Data Exception arrow_forward

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 arrow_forward

22014 ERROR

argument of ntile must be greater than zero — 22014

invalid_argument_for_ntile_function

PostgreSQL error "argument of ntile must be greater than zero" (SQLSTATE 22014, invalid_argument_for_ntile_function): what it means, common causes, and how to fix it.

Data Exception arrow_forward

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 arrow_forward

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 arrow_forward

22015 ERROR

interval field value out of range: “…” — 22015

interval_field_overflow

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

Data Exception arrow_forward

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 arrow_forward

22016 ERROR

argument of nth_value must be greater than zero — 22016

invalid_argument_for_nth_value_function

PostgreSQL error "argument of nth_value must be greater than zero" (SQLSTATE 22016, invalid_argument_for_nth_value_function): what it means, common causes, and how to fix it.

Data Exception arrow_forward

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 arrow_forward

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 arrow_forward

2201B ERROR

Invalid Regular Expression — SQLSTATE 2201B

invalid_regular_expression

A regular expression pattern is invalid.

Data Exception arrow_forward

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 arrow_forward

2201B ERROR

regular expression failed: … — 2201B

invalid_regular_expression

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

Data Exception arrow_forward

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 arrow_forward