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

[PostGIS]

#2182: raster: Possible issue with resize function outdb rasters
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  assigned     
 Priority:  medium  |   Milestone:  PostGIS 2.1.0
Component:  raster  |     Version:  trunk        
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by robe):

 {{{

 gdalinfo "PG:host=localhost port=5432 dbname='fl' user='postgres'
 password='whatever' table=staging_pics_local where='filename=\'Grand
 Caravan.bmp\''"

 }}}

 Returns the below but it resizes fine at 0.5,0.5 haven't tried others.

 {{{
 Driver: PostGISRaster/PostGIS Raster driver
 Files: none associated
 Size is 284, 177
 Origin = (-1890.000000000000000,1890.000000000000000)
 Pixel Size = (3780.000000000000000,-3780.000000000000000)
 Corner Coordinates:
 Upper Left  (   -1890.000,    1890.000)
 Lower Left  (   -1890.000, -667170.000)
 Upper Right ( 1071630.000,    1890.000)
 Lower Right ( 1071630.000, -667170.000)
 Center      (  534870.000, -332640.000)
 Band 1 Block=284x177 Type=Byte, ColorInterp=Red
 Band 2 Block=284x177 Type=Byte, ColorInterp=Green
 Band 3 Block=284x177 Type=Byte, ColorInterp=Blue
 }}}

 My outdb version however which doesn't resize (gives black image)
 {{{gdalinfo "PG:host=localhost port=5432 dbname='fl' user='postgres'
 password='whatever' table=staging_pics_outdb where='filename=\'Grand
 Caravan.bmp\''"}}

 {{{
 Driver: PostGISRaster/PostGIS Raster driver
 Files: none associated
 Size is 284, 177
 Origin = (-1890.000000000000000,1890.000000000000000)
 Pixel Size = (3780.000000000000000,-3780.000000000000000)
 Corner Coordinates:
 Upper Left  (   -1890.000,    1890.000)
 Lower Left  (   -1890.000, -667170.000)
 Upper Right ( 1071630.000,    1890.000)
 Lower Right ( 1071630.000, -667170.000)
 Center      (  534870.000, -332640.000)
 Band 1 Block=284x177 Type=Byte, ColorInterp=Red
 Band 2 Block=284x177 Type=Byte, ColorInterp=Green
 Band 3 Block=284x177 Type=Byte, ColorInterp=Blue
 }}}

 They look the same to me though I would expect the outdb one to say there
 is a file associated with it though.

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