>
> SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
>
>
> the error genrated by above query is:
> SQL error:
>
> ERROR: function addgeometrycolumn(unknown, unknown, integer, unknown,
> integer) does not exist
> LINE 1: SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
> In statement:
>
>
> SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY',2);
You would get that error if you have not loaded the postgis extension
into your database. You need to do something like this, where 'gis' is
the name of the database. This needs to be done as the 'postgres' user:
# for Ubuntu <=9.10:
psql -d gis -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
# for Ubuntu >=10.04:
psql -d gis -f /usr/share/postgresql/8.4/contrib/postgis.sql
For more details about how to setup a typical postgis-enabled DB see
http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS
Jon
_______________________________________________
dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/dev
