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 816 of 3908 errors

22007 ERROR

invalid input syntax for type timestamp: “…” — 22007

invalid_datetime_format

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

Data Exception
22007 ERROR

invalid input syntax for type date: “…” — 22007

invalid_datetime_format

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

Data Exception
22008 ERROR

Datetime Field Overflow — SQLSTATE 22008

datetime_field_overflow

A date/time field is out of range.

Data Exception
22008 ERROR

date/time field value out of range: “…” — 22008

datetime_field_overflow

PostgreSQL error "date/time field value out of range: "…"" (SQLSTATE 22008): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamp out of range — 22008

datetime_field_overflow

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

Data Exception
22008 ERROR

date out of range for type … — 22008

datetime_field_overflow

PostgreSQL error "date out of range for type …" (SQLSTATE 22008): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

date out of range — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

date out of range: “…” — 22008

see SQLSTATE

PostgreSQL error "date out of range: "…"" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

date field value out of range: n-n-n — 22008

datetime_field_overflow

PostgreSQL error "date field value out of range: n-n-n" (SQLSTATE 22008, datetime_field_overflow): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

date out of range: n-n-n — 22008

see SQLSTATE

PostgreSQL error "date out of range: n-n-n" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

cannot subtract infinite dates — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

date out of range for timestamp — 22008

see SQLSTATE

PostgreSQL error "date out of range for timestamp" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

time out of range — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

time field value out of range: n:n:… — 22008

datetime_field_overflow

PostgreSQL error "time field value out of range: n:n:…" (SQLSTATE 22008, datetime_field_overflow): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

value for “…” in source string is out of range — 22008

see SQLSTATE

PostgreSQL error "value for "…" in source string is out of range" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

localized string format value too long — 22008

see SQLSTATE

PostgreSQL error "localized string format value too long" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamp out of range: “…” — 22008

see SQLSTATE

PostgreSQL error "timestamp out of range: "…"" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamp out of range: n-n-n n:n:… — 22008

see SQLSTATE

PostgreSQL error "timestamp out of range: n-n-n n:n:…" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamp cannot be NaN — 22008

see SQLSTATE

PostgreSQL error "timestamp cannot be NaN" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

origin out of range — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

stride must be greater than zero — 22008

see SQLSTATE

PostgreSQL error "stride must be greater than zero" (SQLSTATE 22008, see SQLSTATE): what it means, common causes, and how to fix it.

Data Exception
22008 ERROR

timestamptz out of range — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

timetz out of range — 22008

see SQLSTATE

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

Data Exception
22008 ERROR

cannot subtract infinite timestamps — 22008

see SQLSTATE

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

Data Exception