[postgis-users] Using shp2pgsql

[Paul Maddock]

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 at 01CD22CE.F51BF570]<http://www.ijus.net/index.html>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/a2165f08/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3201 bytes
Desc: image001.gif
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/a2165f08/attachment.gif>