id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 3360,_raster_constraint_info_scale invalid input syntax,robe,robe,"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. ",defect,closed,blocker,PostGIS 2.2.1,raster,2.2.x,fixed,,