[postgis-tickets] [PostGIS] #2777: Huge literal in enforce_max_extent_rast check constraint

Mon Jun 23 10:42:15 PDT 2014

#2777: Huge literal in enforce_max_extent_rast check constraint
--------------------+-------------------------------------------------------
 Reporter:  strk    |       Owner:  dustymugs
     Type:  defect  |      Status:  new      
 Priority:  medium  |   Milestone:           
Component:  raster  |     Version:  trunk    
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by darkblueb):

 quick tests.. using this image
 {{{wget
 http://www.naturalearthdata.com/http//www.naturalearthdata.com/download
 /10m/raster/HYP_HR_SR_OB_DR.zip}}}
 --
 {{{
  POSTGIS="2.2.0dev r12639" GEOS="3.4.1-CAPI-1.8.0 r3894" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" RASTER
 }}}

 {{{
 /usr/lib/postgresql/9.3/bin/raster2pgsql -C -I -s 4326 -Y -t '256x256' -l
 2,4,8,16
  HYP_HR_SR_OB_DR.tif | psql -q ne_test0
 }}}
 {{{
  \d hyp_hr_sr_ob_dr
 ...
 Check constraints:
     "enforce_height_rast" CHECK (st_height(rast) = ANY (ARRAY[256, 48]))
     "enforce_max_extent_rast" CHECK (st_coveredby(st_convexhull(rast),
  '0106000020E61000008801000001030000000100...
 (far too many bytes here) ...
 32BC0D1F9CCCCCCCC28C007EA323333332BC01CC2AAAAAAAA30C007EA323333332BC05007EFEEEEEE34C007EA323333332BC0844C3333333339C0'::geometry))
     "enforce_nodata_values_rast" CHECK
 (_raster_constraint_nodata_values(rast)::numeric(16,10)[] =
 '{NULL,NULL,NULL}'::numeric(16,10)[])
 }}}

 -- test 21
 {{{
  POSTGIS="2.1.4dev r12632" GEOS="3.4.1-CAPI-1.8.0 r3894" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" RASTER
 }}}
 {{{
 $  /usr/lib/postgresql/9.3/bin/raster2pgsql
 RELEASE: 2.1.4dev GDAL_VERSION=110 (r12632)
 }}}