22003 🐘 PostgreSQL

ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3

A number doesn’t fit the column’s numeric(precision, scale) or integer range.

Seen on: PostgreSQL

Meaning

numeric(5,2) allows up to 999.99. integer overflows above 2,147,483,647 (“integer out of range”).

Common causes

  • Value larger than precision allows
  • integer columns for large ids/counters
  • Currency in minor units exceeding int

⚡ Quick fix

  1. Increase precision (numeric(12,2))
  2. Use bigint for large ids/counters

Detailed fix by platform

PostgreSQL

  1. ALTER TABLE orders ALTER COLUMN total TYPE numeric(12,2);

How to diagnose

  1. Column — Type and precision
  2. Value — How large?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.