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

[Jon Burgess]

On Sat, 2010-07-10 at 04:13 +0530, PARVEEN ARORA wrote:
> 
> 
>         
>         
>         >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
> 

That means there was some error earlier in the output, you need to
capture all the messages and find what the first one said. 


> 
> 
> -- 
> With Kind Regards
> Parveen Arora
> osmpunjab.co.cc
>