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 > _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
