Re: BUG #18924: The "ERROR: integer out of range" should be more detailed

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: "sysgeo@gmail.com" <sysgeo@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2025-05-12T12:36:11Z

Lists: pgsql-bugs

On Monday, May 12, 2025, PG Bug reporting form <noreply@postgresql.org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      18924
> Logged by:          Adrien Ducos
> Email address:      sysgeo@gmail.com
> PostgreSQL version: 17.4
> Operating system:   aarch64-unknown-linux-gnu (AWS RDS)
> Description:
>
> --ERROR: integer out of range
> The problem here is not that the integer is out of range (5 billion is out
> of range for the integer type). The problem is that the error message does
> not tell me where the error is in the query.
>
>
This is a known limitation that is looking for someone(s) to volunteer to
do some hard design and development work to overcome.

Some existing thoughts on the topic can be found by searching these mailing
lists.

David J.