[postgis-devel] raster and ~ operator in latest trunk vs r9240 ?

[Nicklas Avén]

I can also change the binaries to latest trunk as long as I use the 
sql-functions from r9240 and it is still working.

so this is working:
"POSTGIS="2.0.0alpha7SVN" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.8.0, 
20 February 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" 
SVN_REVISION=9347 USE_STATS (procs from 2.0 r9155 need upgrade)"


this is not working:
"POSTGIS="2.0.0alpha7SVN r9347" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 
4.8.0, 20 February 2012" GDAL="GDAL 1.9.0, released 2011/12/29" 
LIBXML="2.7.8" USE_STATS (core procs from "2.0.0alpha7SVN r9322" need 
upgrade) (raster procs from "2.0.0alpha7SVN r9322" need upgrade)"


I also tried to upgrade the second one with 
rtpostgis_upgrade_20_minor.sql but get error:

Error:  cannot drop function st_union(raster, text)because extension 
postgis requires it


/Nicklas


On 02/29/2012 01:34 PM, Nicklas Avén wrote:
> Hallo
>
> I can't open rasters in QGIS with latest trunk, but I can with r9240.
>
> I found that in the working r9240 version the query to the databased 
> uses ~ operator to get the right extent. When running the same query 
> in latest trunk I get told that
> (same machine, everything the same, just another postgis version):
>
> operator does not exist: raster ~ geometry
>
> rtpostgis_legacy.sql didn't help
>
>
>
> I also notice that I cannot export my raster ( a 35 mb sat-image) with 
> gdal_translate from latest trunk. I get an output tif of right size 
> but 2/3 of the image is just black.
>
> With r9240 ( that was another machine though so gdal is not exactly 
> the same) it works as expected
>
>
> Thanks
>
> Nicklas
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>