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

22003 ERROR

numeric field overflow — 22003

numeric_value_out_of_range

PostgreSQL error "numeric field overflow" (SQLSTATE 22003): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

integer out of range — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

value out of range: overflow — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

value out of range: underflow — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

bigint out of range — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

smallint out of range — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

“wait_seconds” must not be negative or zero — 22003

numeric_value_out_of_range

PostgreSQL error ""wait_seconds" must not be negative or zero" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

lo_lseek result out of range for large-object descriptor n — 22003

numeric_value_out_of_range

PostgreSQL error "lo_lseek result out of range for large-object descriptor n" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

lo_tell result out of range for large-object descriptor n — 22003

numeric_value_out_of_range

PostgreSQL error "lo_tell result out of range for large-object descriptor n" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

“timeout” must not be negative — 22003

numeric_value_out_of_range

PostgreSQL error ""timeout" must not be negative" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

money out of range — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

input is out of range — 22003

numeric_value_out_of_range

PostgreSQL error "input is out of range" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

result is out of range — 22003

numeric_value_out_of_range

PostgreSQL error "result is out of range" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

factorial of a negative number is undefined — 22003

numeric_value_out_of_range

PostgreSQL error "factorial of a negative number is undefined" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

value overflows numeric format — 22003

numeric_value_out_of_range

PostgreSQL error "value overflows numeric format" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

percentile value … is not between 0 and 1 — 22003

numeric_value_out_of_range

PostgreSQL error "percentile value … is not between 0 and 1" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

number is out of range — 22003

numeric_value_out_of_range

PostgreSQL error "number is out of range" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

macaddr8 data out of range to convert to macaddr — 22003

numeric_value_out_of_range

PostgreSQL error "macaddr8 data out of range to convert to macaddr" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

block number out of range: n — 22003

numeric_value_out_of_range

PostgreSQL error "block number out of range: n" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

n is outside the valid range for parameter “…” (n .. n) — 22003

numeric_value_out_of_range

PostgreSQL error "n is outside the valid range for parameter "…" (n .. n)" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

setval: value n is out of bounds for sequence “…” (n..n) — 22003

numeric_value_out_of_range

PostgreSQL error "setval: value n is out of bounds for sequence "…" (n..n)" (SQLSTATE 22003, numeric_value_out_of_range): what it means, common causes, and how to fix it.

Data Exception
22003 ERROR

value “…” is out of range for type … — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

“char” out of range — 22003

numeric_value_out_of_range

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

Data Exception
22003 ERROR

“…” is out of range for type real — 22003

numeric_value_out_of_range

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

Data Exception