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 [cid:image001.gif@01CD22CE.F51BF570]<http://www.ijus.net/index.html>
<<inline: image001.gif>>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users