[postgis-users] Numeric overflow when inserting large polygons

[strk]

tschaun wrote:
> Dear listers,
> 
> I have just finished installing PostgreSQL 7.4 and PostGIS 0.8 on a RedHat 9
> machine. The installation seems to have gone fine and everything usually
> works as expected. However, I'm having trouble with a few very large
> polygons in my test layers that cause a numeric overflow error when I try to
> enter them into PostGIS tables using SQL code generated by shp2pgsql.
> "ERROR: numeric field overflow. DETAIL: The absolute value is greater than
> or equal to 10^8 for field with precision 19, scale 11."

I think this has nothing to do with the geometry field, but rather with
one of the associated values (attributes in the .dbf file).
Open the output of shp2pgsql and see how numeric fields are defined in
the CREATE TABLE statement.

--strk;