[OSM-dev] [OSM-Dev]Add Geometry Column in PostgreSQl

[PARVEEN ARORA]

> >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


    Thank You for your help,

     i am using ubuntu 10.04 so i have run the command given by you after
login to postgresql

        but after creating some funstions this command also ends up with
some errors
        for e.g.

psql:/usr/share/postgresql/8.4/contrib/postgis.sql:6826: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:6944: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
psql:/usr/share/postgresql/8.4/contrib/postgis.sql:6949: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
ROLLBACK



-- 
With Kind Regards
Parveen Arora
osmpunjab.co.cc
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100710/c5200961/attachment.html>