{"record":{"id":"a9ace7ade6f0344c","repo":"jackc/pgx","slug":"d-is-greater-than-maximum-value-for-int4-a9ace7","errorCode":null,"errorMessage":"%d is greater than maximum value for int4","messagePattern":"(.+?) is greater than maximum value for int4","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"pgtype/int.go","lineNumber":756,"sourceCode":"func (encodePlanInt4CodecTextInt32) Encode(value any, buf []byte) (newBuf []byte, err error) {\n\tn := value.(int32)\n\treturn append(buf, strconv.FormatInt(int64(n), 10)...), nil\n}\n\ntype encodePlanInt4CodecBinaryInt64Valuer struct{}\n\nfunc (encodePlanInt4CodecBinaryInt64Valuer) Encode(value any, buf []byte) (newBuf []byte, err error) {\n\tn, err := value.(Int64Valuer).Int64Value()\n\tif err != nil {\n\t\treturn nil, err\n\t}\n\n\tif !n.Valid {\n\t\treturn nil, nil\n\t}\n\n\tif n.Int64 > math.MaxInt32 {\n\t\treturn nil, fmt.Errorf(\"%d is greater than maximum value for int4\", n.Int64)\n\t}\n\tif n.Int64 < math.MinInt32 {\n\t\treturn nil, fmt.Errorf(\"%d is less than minimum value for int4\", n.Int64)\n\t}\n\n\treturn pgio.AppendInt32(buf, int32(n.Int64)), nil\n}\n\ntype encodePlanInt4CodecTextInt64Valuer struct{}\n\nfunc (encodePlanInt4CodecTextInt64Valuer) Encode(value any, buf []byte) (newBuf []byte, err error) {\n\tn, err := value.(Int64Valuer).Int64Value()\n\tif err != nil {\n\t\treturn nil, err\n\t}\n\n\tif !n.Valid {\n\t\treturn nil, nil","sourceCodeStart":738,"sourceCodeEnd":774,"githubUrl":"https://github.com/jackc/pgx/blob/ec1a0befd22592cffffdeeb0a50311b506372f4c/pgtype/int.go#L738-L774","documentation":"Encoding an Int64Valuer into an int4 (integer) column in binary format failed the range check: the value exceeds math.MaxInt32. The Go value whose Int64Value() is too large for integer is the faulting input.","triggerScenarios":"Thrown at pgtype/int.go:756 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Use an int8 parameter type for the value","Validate/clamp the value to the int4 range before encoding"],"exampleFix":null,"handlingStrategy":"validation","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"ec1a0befd22592cffffdeeb0a50311b506372f4c","analyzedAt":"2026-08-04T22:52:11.263Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-23T08:17:48.524Z"}