[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