[OSM-newbies] osm2pgsql error

Lars Francke lars.francke at gmail.com
Sat Nov 1 14:27:50 GMT 2008


Hi,

> SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, 'POINT', 2 );
>  failed: ERROR:  function addgeometrycolumn(unknown, unknown, integer,
> unknown, integer) does not exist
> LINE 2: SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, 'P...
>               ^
> HINT:  No function matches the given name and argument types. You
> might need to add explicit type casts.

do you have PostGIS installed? (http://postgis.refractions.net/)
PostGIS adds the AddGeometryColumn function to PostgreSQL and it looks
like it cannot be found.

If you have it installed perhaps you have forgotten to use
template_postgis as a template for your database?
CREATE DATABASE osm TEMPLATE=template_postgis;
Would be the correct statement.

Hope that helps.




More information about the newbies mailing list