Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow
Date
Msg-id CADK3HHJP9v_wFBJvZwyyWZwM=z85rKKAcGGqAeHYD3f6Jg4SoA@mail.gmail.com
Whole thread Raw
In response to Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc


On Sun, 6 Feb 2022 at 11:45, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thomas Markus <t.markus@proventis.net> writes:
> a customer got the exception "org.postgresql.util.PSQLException: ERROR:
> value out of range: underflow" without any stacktrace etc.

I'd venture that the cause is some server-side double precision
arithmetic that underflowed.  It's not that hard to hit, eg

postgres=# select 1e-200::float8 * 1e-200::float8;
ERROR:  value out of range: underflow

                        regards, tom lane
I mistakenly responded privately and OP responded to that.

Turns out a column was added with the wrong type.

Dave

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow
Next
From: Thomas Markus
Date:
Subject: Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow