From 89d169e8dc32253d3ac7ed82b5a6d132e84adf6b Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 3 Dec 2014 23:28:59 +0000 Subject: [PATCH] #3006 Numeric overflow when executing AddRasterConstraints, increased precision to 25,10 git-svn-id: http://svn.osgeo.org/postgis/trunk@13136 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/raster/rt_pg/rtpostgis.sql.in b/raster/rt_pg/rtpostgis.sql.in index bbba976e7..5d26e91bc 100644 --- a/raster/rt_pg/rtpostgis.sql.in +++ b/raster/rt_pg/rtpostgis.sql.in @@ -6965,7 +6965,7 @@ CREATE OR REPLACE FUNCTION _add_raster_constraint_scale(rastschema name, rasttab || ' ADD CONSTRAINT ' || quote_ident(cn) || ' CHECK (st_scale' || $4 || '(' || quote_ident($3) - || ')::numeric(16,10) = (' || attr || ')::numeric(16,10))'; + || ')::numeric(25,10) = (' || attr || ')::numeric(25,10))'; RETURN _add_raster_constraint(cn, sql); END; $$ LANGUAGE 'plpgsql' VOLATILE STRICT -- 2.50.1