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

**Code:** `22003` · **Category:** PostgreSQL · **Seen on:** PostgreSQL

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

## 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?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/postgresql/numeric-field-overflow)
