jackc/pgx · error

int8

Error message

int8: %w

What it means

scanPlanBinaryInt8ToInt8 wraps pgio.Uint64Exact: the binary int8 payload was not exactly 8 bytes, so it cannot be interpreted as an int8. The wrapped error details the size mismatch.

Solutions

1. Treat as protocol/data corruption — verify the column is bigint
2. Check for driver/server version mismatch

When it happens

Trigger: Thrown at pgtype/int.go:1468 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/422bb4c906509159. Report an issue: GitHub.

Appendix: source

Thrown at pgtype/int.go:1468

	var n int64
	err := codecScan(c, m, oid, format, src, &n)
	if err != nil {
		return nil, err
	}
	return n, nil
}

type scanPlanBinaryInt8ToInt8 struct{}

func (scanPlanBinaryInt8ToInt8) Scan(src []byte, dst any) error {
	if src == nil {
		return fmt.Errorf("cannot scan NULL into %T", dst)
	}

	raw, err := pgio.Uint64Exact(src)
	if err != nil {
		return fmt.Errorf("int8: %w", err)
	}

	p, ok := (dst).(*int8)
	if !ok {
		return ErrScanTargetTypeChanged
	}

	n := int64(raw)
	if n < math.MinInt8 {
		return fmt.Errorf("%d is less than minimum value for int8", n)
	} else if n > math.MaxInt8 {
		return fmt.Errorf("%d is greater than maximum value for int8", n)
	}

	*p = int8(n)

	return nil
}

View on GitHub (pinned to ec1a0befd2)