[postgis-tickets] [PostGIS] #2182: raster: Possible issue with resize function

[PostGIS]

#2182: raster: Possible issue with resize function
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  medium  |   Milestone:  PostGIS 2.1.0
Component:  raster  |     Version:  trunk        
 Keywords:          |  
--------------------+-------------------------------------------------------
 I have this folder of aircraft pictures that I registered as outdb and
 then ran a query for resizing.  They are all bmp files and for some reason
 some of them when I resize turn black. It doesn't seem to matter what
 percent or width /height I apply for resizing.

 The commands I am using to register are:

 {{{
 raster2pgsql -F -Y -R C:/jet_photos/*.bmp staging_pics | psql
 }}}

 The query I was using to get resized versions looks like this:


 {{{
 SELECT
   ST_AsPNG(ST_Resize(rast,0.5,0.5 )) As thumb_pic
 FROM staging_pics WHERE filename = 'Grand Caravan.bmp';

 }}}


 A lot of them resize fine and some don't but all look okay if no resize
 operation is applied.

 I'm using the latest winnie 64-bit 9.2 buildbot build.

 {{{
 PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit
 POSTGIS="2.1.0SVN r11004" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" RASTER
 }}}

 I'll send you a couple of good and bad pictures (those that resize fine
 and some that don't).  I would attach to this ticket, but they are client
 pictures so can't disclose publicly.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2182>
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.