Numerical field overflow - which field?

In case of error:

PG :: Error: ERROR: numerical field overflow DETAILED DESCRIPTION: Field with accuracy 2, scale 2 must be rounded to an absolute value of less than 1

How to configure postgres or ruby โ€‹โ€‹/ rails_4 pg library to tell me which field is causing the error? A clear error message would be:

PG :: Error: ERROR: numeric field overflow. Field "pressure", value "1111.12"

+6
source share
1 answer

This is a limitation of PostgreSQL error reporting and cannot be configured using PostgreSQL, rails or pg pearls.

+1
source

Source: https://habr.com/ru/post/948935/


All Articles