[postgis-users] Shape File data loader

[Paul Ramsey]

You'll have to get the front of your error log to find the "interesting" 
error message. Try running sql file in pgadin, you might find it easier 
to see the first error.
P

Jeff Grice wrote:

> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users