node-postgres icon indicating copy to clipboard operation
node-postgres copied to clipboard

How to find an error in the query

Open fabricenl opened this issue 3 years ago • 0 comments

I get a very generic error on an issue but I don't get information what column it is. How can I retrieve that information?

error: numeric field overflow 1|job | at Parser.parseErrorMessage (/root/jobBuilder/node_modules/pg-protocol/dist/parser.js:287:98) 1|job | at Parser.handlePacket (/root/jobBuilder/node_modules/pg-protocol/dist/parser.js:126:29) 1|job | at Parser.parse (/root/jobBuilder/node_modules/pg-protocol/dist/parser.js:39:38) 1|job | at Socket. (/root/jobBuilder/node_modules/pg-protocol/dist/index.js:11:42) 1|job | at Socket.emit (node:events:527:28) 1|job | at addChunk (node:internal/streams/readable:315:12) 1|job | at readableAddChunk (node:internal/streams/readable:289:9) 1|job | at Socket.Readable.push (node:internal/streams/readable:228:10) 1|job | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { 1|job | length: 164, 1|job | severity: 'ERROR', 1|job | code: '22003', 1|job | detail: 'A field with precision 6, scale 3 must round to an absolute value less than 10^3.', 1|job | hint: undefined, 1|job | position: undefined, 1|job | internalPosition: undefined, 1|job | internalQuery: undefined, 1|job | where: undefined, 1|job | schema: undefined, 1|job | table: undefined, 1|job | column: undefined, 1|job | dataType: undefined, 1|job | constraint: undefined, 1|job | file: 'numeric.c', 1|job | line: '7476', 1|job | routine: 'apply_typmod' 1|job | }

fabricenl avatar May 30 '22 13:05 fabricenl