Numeric value out of range

Common SQL Errors

Runtime

Overflow (e.g., inserting 1000000 into a SMALLINT)

PostgreSQL
Sign up for the latest in common SQL errors from the Galaxy Team!
Welcome to the Galaxy, Guardian!
Oops! Something went wrong while submitting the form.

Typical Error Message

Numeric value out of range

Explanation

This error arises when a numeric value exceeds the allowed range for its data type. Use a larger type like BIGINT.

Common Causes

Exceeding SMALLINT or INT limits

Related Errors

FAQs

Check out some other errors

Trusted by top engineers on high-velocity teams
Aryeo Logo
Assort Health
Curri
Rubie
BauHealth Logo
Truvideo Logo
Welcome to the Galaxy, Guardian!
Oops! Something went wrong while submitting the form.