[gdal-dev] raster2pgsql: AddRasterColumn / No function matches the given name and argument types

Sebastian Schutte sebastian.schutte at icr.gess.ethz.ch
Thu Sep 8 08:18:56 EDT 2011


Dear gdal-dev list,

I followed Jorge Arevalo's tutorial at
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html in order to test
the postgis 2.0 raster support on our RHEL Linux machine. The entire
postgresql, postgis 2.0, gdal, proj, and geos collection is compiled
from source. I have raster support working in the DB and I can see the
addrastercolumn function in pgadmin, but I still get errors following
the tutorial:

LINE 1: SELECT AddRasterColumn('public','katrina','rast',4326, ARRAY...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
psql:./katrina.sql:4: ERROR: current transaction is aborted, commands
ignored until end of transaction block
...

The Postgis Installation seems to be working:
SELECT postgis_full_version();
                                          postgis_full_version
       ---------------------------------------------------------------------
 POSTGIS="2.0.0SVN" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23
September 2009" LIBXML="2.7.6" USE_STATS
(1 row)

I also compiled GDAL with python bindings and Postgis with raster support...
Does anyone have a solution for this problem? What am I missing?

Thanks so much for your help!

Best wishes,
Sebastian


More information about the gdal-dev mailing list