[postgis-users] raster2pgsql: AddRasterColumn / No function matches the given name and argument

[Sebastian Schutte]

Dear postgis-dev list,

I followed Jorge Arevalo's tutorial
athttp://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)

Jorge pointed me to the possibility that raster support is not enabled,
however the "raster_columns" and "raster_overviews" are there, and the
postgis build is "2.0.0SVN" from "2011-09-07 12:09:37".

Do you think the PostGIS Bug #1175 could be related to this
(http://old.nabble.com/-PostGIS---1175%3A-AddRasterColumn-is-broken-td32348025.html)?
I also compiled GDAL with python bindings and Postgis with raster support...

The commands I executed are:
python /usr/local/pgsql/bin/raster2pgsql.py -r ./katrina.tif -t katrina
-l 1 -k 64x64 -o katrina.sql -s 4326 -I -M
#And then
/usr/local/pgsql/bin/psql -d growup -f ./katrina.sql -U postgres

Does anyone have a solution for this problem? What am I missing?

Thanks so much for your help!
Best wishes,
Sebastian