[raster]: Can't read out_db jpg in some cases
|Reported by:||robe||Owned by:||Bborie Park|
This might be similar issue to what we've had before, but I get a set of project photos, but unfortunately all the ones exhibiting the problem are too big to attach.
When I do this or ST_AsPNG
SELECT ST_Resize(rast,0.1,0.1) FROM armory_outdb limit 1
I get this error
NOTICE: The in-db representation of the out-db raster is not aligned. Band data may be incorrect CONTEXT: PL/pgSQL function st_resize(raster,double precision,double precision,text,double precision) line 23 at RETURN ERROR: rt_raster_from_gdal_dataset: Unable to get data from GDAL raster CONTEXT: PL/pgSQL function st_resize(raster,double precision,double precision,text,double precision) line 23 at RETURN
This issue doesn't happen if I load in db.
Command I used is:
raster2pgsql -F -Y -R C:/pics/back.jpg armory_outdb | psql -U postgres -d testpostgis21 -h localhost -p 5442
POSTGIS="2.1.0SVN r11085" 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" (core procs from "2.1.0SVN r11079" need upgrade) RASTER (raster procs from "2.1.0SVN r11079" need upgrade)
I'll send you link in a bit.