jackc/pgx · error

is greater than maximum value for int32

Error message

%d is greater than maximum value for int32

What it means

Range guard converting an int64 into Go int32: the value exceeds math.MaxInt32 and would overflow, so the conversion is refused.

Solutions

1. Scan into int64 or pgtype.Int8
2. Widen the column type or constrain values in SQL

When it happens

Trigger: Thrown at pgtype/builtin_wrappers.go:75 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of jackc/pgx@ec1a0befd2 (2026-08-04). Data as JSON: /api/errors/02284044c68d51d5. Report an issue: GitHub.

Appendix: source

Thrown at pgtype/builtin_wrappers.go:75

func (w int16Wrapper) Int64Value() (Int8, error) {
	return Int8{Int64: int64(w), Valid: true}, nil
}

type int32Wrapper int32

func (w int32Wrapper) SkipUnderlyingTypePlan() {}

func (w *int32Wrapper) ScanInt64(v Int8) error {
	if !v.Valid {
		return fmt.Errorf("cannot scan NULL into *int32")
	}

	if v.Int64 < math.MinInt32 {
		return fmt.Errorf("%d is less than minimum value for int32", v.Int64)
	}
	if v.Int64 > math.MaxInt32 {
		return fmt.Errorf("%d is greater than maximum value for int32", v.Int64)
	}
	*w = int32Wrapper(v.Int64)

	return nil
}

func (w int32Wrapper) Int64Value() (Int8, error) {
	return Int8{Int64: int64(w), Valid: true}, nil
}

type int64Wrapper int64

func (w int64Wrapper) SkipUnderlyingTypePlan() {}

func (w *int64Wrapper) ScanInt64(v Int8) error {
	if !v.Valid {
		return fmt.Errorf("cannot scan NULL into *int64")
	}

View on GitHub (pinned to ec1a0befd2)