Re: [postgis-users] Using shp2pgsql

[Denis Rouzaud]

You could output shp2pgsql to a SQL file, then use it in psql to see at which line the error occurs. On 04/25/2012 04:46 PM, Paul Maddock wrote: Dear all,   I’m using the following code to transform a shapefile I have into a table and import it into my database: shp2pgsql -s 3754 ~/JOE/columbus/pole_region.shp columbus.pole_region | psql -h localhost -U postgres -p 5432 -d paul   When it runs I have to put my password in for postgres (expected), and I get the following output:   ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block ERROR:  current transaction is aborted, commands ignored until end of transaction block   The database paul is created and the schema columbus is created and is owned by postgres.   What am I doing wrong?  Do I have to set datatypes?   Thanks for the help, Paul     Paul A. Maddock Mapping Technician IJUS LLC 560 Officenter Place Gahanna, OH 43230 Cell: (513) 404-6476   _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users