[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
>
> Description: Description: Home <http://www.ijus.net/index.html>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/36165d33/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3201 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120425/36165d33/attachment.gif>