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

From Tom Lane
Subject Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow
Date
Msg-id 720183.1644165943@sss.pgh.pa.us
Whole thread Raw
In response to org.postgresql.util.PSQLException: ERROR: value out of range: underflow  (Thomas Markus <t.markus@proventis.net>)
Responses Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow  (Dave Cramer <davecramer@postgres.rocks>)
Re: org.postgresql.util.PSQLException: ERROR: value out of range: underflow  (Thomas Markus <t.markus@proventis.net>)
List pgsql-jdbc
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



pgsql-jdbc by date:

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