{"record":{"id":"741d996d7c1c6b8f","repo":"JuliusBrussee/caveman","slug":"json-number-exceeds-postgresql-integer-digit-limit","errorCode":null,"errorMessage":"JSON number exceeds PostgreSQL integer-digit limit","messagePattern":"JSON number exceeds PostgreSQL integer-digit limit","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"shared/platform/proposalrun/proposalrun.go","lineNumber":249,"sourceCode":"\t\treturn \"\", fmt.Errorf(\"JSON number exceeds PostgreSQL fraction-digit limit\")\n\t}\n\n\tdigits := strings.TrimLeft(integerPart+fractionPart, \"0\")\n\tif digits == \"\" {\n\t\treturn \"0\", nil\n\t}\n\tscale := len(fractionPart) - exponent\n\tfor scale > 0 && strings.HasSuffix(digits, \"0\") {\n\t\tdigits = digits[:len(digits)-1]\n\t\tscale--\n\t}\n\n\tvar out string\n\tswitch {\n\tcase scale <= 0:\n\t\tzeros := -scale\n\t\tif zeros > maxJSONBNumericIntegerDigits-len(digits) {\n\t\t\treturn \"\", fmt.Errorf(\"JSON number exceeds PostgreSQL integer-digit limit\")\n\t\t}\n\t\tout = digits + strings.Repeat(\"0\", zeros)\n\tcase scale >= len(digits):\n\t\tif scale > maxJSONBNumericFractionDigits {\n\t\t\treturn \"\", fmt.Errorf(\"JSON number exceeds PostgreSQL fraction-digit limit\")\n\t\t}\n\t\tout = \"0.\" + strings.Repeat(\"0\", scale-len(digits)) + digits\n\tdefault:\n\t\tif scale > maxJSONBNumericFractionDigits || len(digits)-scale > maxJSONBNumericIntegerDigits {\n\t\t\treturn \"\", fmt.Errorf(\"JSON number exceeds PostgreSQL numeric limits\")\n\t\t}\n\t\tpoint := len(digits) - scale\n\t\tout = digits[:point] + \".\" + digits[point:]\n\t}\n\tif negative {\n\t\treturn \"-\" + out, nil\n\t}\n\treturn out, nil","sourceCodeStart":231,"sourceCodeEnd":267,"githubUrl":"https://github.com/JuliusBrussee/caveman/blob/27d5a3981a347890211bb1bf2439e5c821a63bc9/shared/platform/proposalrun/proposalrun.go#L231-L267","documentation":"Error \"JSON number exceeds PostgreSQL integer-digit limit\" thrown in JuliusBrussee/caveman.","triggerScenarios":"Thrown at shared/platform/proposalrun/proposalrun.go:249 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Reduce the number's integer digits below the PostgreSQL limit."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"27d5a3981a347890211bb1bf2439e5c821a63bc9","analyzedAt":"2026-08-15T09:26:11.751Z","schemaVersion":2},"datasetVersion":"2026-08-15T17:31:12.345Z"}