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

[Jorge Arévalo]

On Thu, Sep 8, 2011 at 2:18 PM, Sebastian Schutte
<sebastian.schutte at icr.gess.ethz.ch> wrote:
> 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
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>

Hi Sebastian,

Seems that the PostGIS Raster support isn't correctly installed. How
did you enable your database with PostGIS and PostGIS Raster? which
version of GDAL and PostGIS are you using?

Please, do these tests:

- Check if your database has "raster_columns" and "raster_overviews" tables
- Execute this query, and get the result: "select
postgis_raster_lib_version(), postgis_raster_lib_build_date()"

Anyway, I think the best way to answer these questions is the
postgis-users list (I put it in copy), not the gdal-dev list.

Best regards,

-- 
Jorge Arévalo
Internet & Mobility Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g