[postgis-devel] raster and ~ operator in latest trunk vs r9240 ?
nicklas.aven at jordogskog.no
Wed Feb 29 04:43:51 PST 2012
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
On 02/29/2012 01:34 PM, Nicklas Avén wrote:
> 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
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
More information about the postgis-devel