[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

_______________________________________________
postgis-users mailing list
postgi...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Paragon Corporation]

>
> Do you think the PostGIS Bug #1175 could be related to this
> (http://old.nabble.com/-PostGIS---1175%3A-AddRasterColumn-is-b
> roken-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
>

Sebastian,

You can just reinstall the rtpostgis.sql file to make sure you
are up to date. Structurs haven't changed but the Addraster.. ws fixed.

Just ignore the errors you see.

Alternatically you can just copy and reinstall the
AddRasterColumn functions from the rtpostgis.sql

but just runnning that portion of the script.

Hope that helps,
Regina
http://www.postgis.us

[Sebastian Schutte]

Dear Regina,

thanks for the hint. Jorge Arévalo already pointed me into a similar
direction. I recompiled the sources according to his suggestions and
used the latest svn revision instead of the tar ball. This solved the issue!

Thanks to both of you,
Sebastian

--
Sebastian Schutte
International Conflict Research
ETH Zurich
http://www.icr.ethz.ch/people/schutte