[postgis-users] Shape File data loader

Jeff Grice jgrice at predictioncompany.com
Mon Jun 20 13:29:00 PDT 2005


Hello all,

 

I am a new PostGIS user and had a question regarding loading data into
the database using the shp2pgsql.

 

I am running PostgreSQL 8.0.2 and PostGIS 0.9 on WindowsXP.

 

I issue the following command:

 

Shp2pgsql -s 27700 level5streets.shp lv5_street GIS_db > streets.sql

Psql -d GIS_db -f lv5_street.sql

 

The shp2pgsql command executes and generates the *.sql file, but when I
run the psql command it returns an error for each record :

 

ERROR: current transaction is aborted, commands ignored until end of
transaction block

 

 

Any ideas on where I am going wrong?

 

TIA,

 

Jeff Grice

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050620/9d8fdb8b/attachment.html>


More information about the postgis-users mailing list