[OSM-newbies] osm2pgsql error

[Nick Black]

Rai - posting on dev would probably be more useful for you.

http://lists.openstreetmap.org/listinfo/dev


On Sat, Nov 1, 2008 at 2:27 PM, Lars Francke <lars.francke at gmail.com> wrote:

> 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.
>
> _______________________________________________
> newbies mailing list
> newbies at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/newbies
>



-- 
Nick Black
--------------------------------
http://www.blacksworld.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/newbies/attachments/20081101/9bacbe18/attachment.html>