PostgreSQL Error Reference

Every error, explained

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

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 840 of 3908 errors

22008 ERROR

cannot convert infinite interval to time — 22008

see SQLSTATE

PostgreSQL error "cannot convert infinite interval to time" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

cannot add infinite interval to time — 22008

see SQLSTATE

PostgreSQL error "cannot add infinite interval to time" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

cannot subtract infinite interval from time — 22008

see SQLSTATE

PostgreSQL error "cannot subtract infinite interval from time" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamps cannot be binned into infinite intervals — 22008

see SQLSTATE

PostgreSQL error "timestamps cannot be binned into infinite intervals" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22009 ERROR

Invalid Time Zone Displacement Value — SQLSTATE 22009

invalid_time_zone_displacement_value

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

Data Exception
22009 ERROR

time zone displacement out of range — 22009

invalid_time_zone_displacement_value

PostgreSQL error "time zone displacement out of range" (SQLSTATE 22009, invalid_time_zone_displacement_value): what it means, common causes, and how to fix it.

Data Exception
22009 ERROR

time zone displacement out of range: “…” — 22009

invalid_time_zone_displacement_value

PostgreSQL error "time zone displacement out of range: "…"" (SQLSTATE 22009, invalid_time_zone_displacement_value): what it means, common causes, and how to fix it.

Data Exception
2200B ERROR

Escape Character Conflict — SQLSTATE 2200B

escape_character_conflict

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

Data Exception
2200C ERROR

Invalid Use Of Escape Character — SQLSTATE 2200C

invalid_use_of_escape_character

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

Data Exception
2200C ERROR

SQL regular expression may not contain more than two escape-double-… — 2200C

invalid_use_of_escape_character

PostgreSQL error "SQL regular expression may not contain more than two escape-double-quote separators" (SQLSTATE 2200C, invalid_use_of_escape_character): what it means, common causes, and how to fix it.

Data Exception
2200D ERROR

Invalid Escape Octet — SQLSTATE 2200D

invalid_escape_octet

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

Data Exception
2200F ERROR

Zero Length Character String — SQLSTATE 2200F

zero_length_character_string

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

Data Exception
2200F ERROR

lexeme array may not contain empty strings — 2200F

zero_length_character_string

PostgreSQL error "lexeme array may not contain empty strings" (SQLSTATE 2200F, zero_length_character_string): what it means, common causes, and how to fix it.

Data Exception
2200G ERROR

Most Specific Type Mismatch — SQLSTATE 2200G

most_specific_type_mismatch

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

Data Exception
2200H ERROR

Sequence Generator Limit Exceeded — SQLSTATE 2200H

sequence_generator_limit_exceeded

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

Data Exception
2200H ERROR

nextval: reached maximum value of sequence “…” (n) — 2200H

sequence_generator_limit_exceeded

PostgreSQL error "nextval: reached maximum value of sequence "…" (n)" (SQLSTATE 2200H, sequence_generator_limit_exceeded): what it means, common causes, and how to fix it.

Data Exception
2200H ERROR

nextval: reached minimum value of sequence “…” (n) — 2200H

sequence_generator_limit_exceeded

PostgreSQL error "nextval: reached minimum value of sequence "…" (n)" (SQLSTATE 2200H, sequence_generator_limit_exceeded): what it means, common causes, and how to fix it.

Data Exception
2200H ERROR

nextval: reached maximum value of sequence “…” (% — 2200H

sequence_generator_limit_exceeded

PostgreSQL error "nextval: reached maximum value of sequence "…" (%" (SQLSTATE 2200H, sequence_generator_limit_exceeded): what it means, common causes, and how to fix it.

Data Exception
2200H ERROR

nextval: reached minimum value of sequence “…” (% — 2200H

sequence_generator_limit_exceeded

PostgreSQL error "nextval: reached minimum value of sequence "…" (%" (SQLSTATE 2200H, sequence_generator_limit_exceeded): what it means, common causes, and how to fix it.

Data Exception
2200L ERROR

Not An Xml Document — SQLSTATE 2200L

not_an_xml_document

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

Data Exception
2200L ERROR

not an XML document — 2200L

not_an_xml_document

PostgreSQL error "not an XML document" (SQLSTATE 2200L, not_an_xml_document): what it means, common causes, and how to fix it.

Data Exception
2200M ERROR

Invalid Xml Document — SQLSTATE 2200M

invalid_xml_document

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

Data Exception
2200N ERROR

Invalid Xml Content — SQLSTATE 2200N

invalid_xml_content

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

Data Exception
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