[postgis-tickets] [PostGIS] #3360: _raster_constraint_info_scale invalid input syntax

[PostGIS]

#3360: _raster_constraint_info_scale invalid input syntax
---------------------+---------------------------
 Reporter:  robe     |      Owner:  dustymugs
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.2.1
Component:  raster   |    Version:  2.2.x
 Keywords:           |
---------------------+---------------------------
 We may have a ticket in for this already.  In trying to test out QGIS
 issue mentioned here:

 https://lists.osgeo.org/pipermail/postgis-users/2015-November/040909.html


 I'm running:


 {{{
 PostgreSQL 9.5beta1, compiled by Visual C++ build 1800, 64-bit
 POSTGIS="2.2.0 r14208" GEOS="3.5.0-CAPI-1.9.0 r4090" PROJ="Rel. 4.9.1, 04
 March 2015" GDAL="GDAL 2.0.1, released 2015/09/15" LIBXML="2.7.8"
 LIBJSON="0.12" RASTER
 }}}


 I decided to load up some rasters. I can see my picture raster with no
 constraints fine.

 When I loaded up -
 http://biogeo.ucdavis.edu/data/climate/worldclim/1_4/tiles/cur/prec_25.zip

 Using:


 {{{
 raster2pgsql -s 4326 -I -C -M prec/*.bil -F -t 256x256 ch12.prec | psql
 }}}

 Loaded fine, but when tried to view in QGIS 2.12.0 nothing showed up. My
 postgres logs show a long query which looks very similar to raster_columns
 view.

 with error:


 {{{
 ERROR:  invalid input syntax for type double precision:
 "0.00833333333333333,10"
 CONTEXT:  SQL function "_raster_constraint_info_scale" statement 1
 }}}

 Doing


 {{{
 SELECT * FROM raster_columns;
 }}}

 generates the same error.  I think I've tried vieiwng this in 2.1 before
 when I wrote the book and was fine viewing in QGIS.  I'll try to relaod in
 2.1 to confirm it's a  2.2. issue.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3360>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.