id summary reporter owner description type status priority milestone component version resolution keywords cc 2188 [raster] Issue with ST_Resize percent doesn't work always for non-georeferenced affects both in db and out db robe Bborie Park "Okay I have more pictures but these are property inspection ones in jpeg. For this set ST_Resize using percentage doesn't seem to work: {{{ ST_Resize(rast,0.5,0.5) }}} for any of them regardless of if I have outdb or indb. However if I do pixel size like {{{ ST_Resize(rast,100,100) }}} That works fine. I'm not sure if it's related to: #2182 and possibly a windows 2008 specific issue. I'll check on my Windows 2003 64-bit server to verify it happens on that as well: Any rate: {{{ raster2pgsql -F -Y -R C:/photos/*.jpg inspection_pics_outdb | psql }}} {{{ raster2pgsql -F -Y C:/photos/*.jpg inspection_pics_local | psql }}} {{{ SELECT version() || ' ' || postgis_full_version(); -- outputs -- PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit POSTGIS=""2.1.0SVN r11044"" GEOS=""3.4.0dev-CAPI-1.8.0 r0"" PROJ=""Rel. 4.8.0, 6 March 2012"" GDAL=""GDAL 1.9.2, released 2012/10/08"" LIBXML=""2.7.8"" LIBJSON=""UNKNOWN"" TOPOLOGY (topology procs from ""2.1.0SVN r10987"" need upgrade) RASTER and this is on a Windows 2008 R2 64-bit VM }}} {{{ -- works -- SELECT ST_Resize(rast,200,200) FROM inspection_pics_local WHERE filename='PHOTO_1_20080101_121112.jpg' }}} {{{ -- returns a black image -- SELECT ST_Resize(rast,0.5,0.5) FROM inspection_pics_local WHERE filename='PHOTO_1_20080101_121112.jpg' }}} I'm attaching one of the problem pics this one is public record inspections so no issue attaching pic." defect closed critical PostGIS 2.1.0 raster master fixed