"Mitch Vincent" <mitch@venux.net> writes:
> Query Failed
> ERROR: overflow on numeric ABS(value) >= 10^2 for field with precision 0
> scale 2
That's a known bug in the NUMERIC code --- cause not known yet, but
apparently it's somewhat platform-dependent (or maybe there's more
than one bug?). I've been expecting Jan Wieck to produce a fix, since
NUMERIC is his turf, but he may be too busy with long-tuple support to
want to look at it.
One way or another it will get seen to before 7.0 beta, and hopefully
we can produce a back-patch for 6.5.* as well.
regards, tom lane