[postgis-users] Shape File data loader

[Ethan Alpert]

One thing I always run into with a clean install is I don't have
permission to modify the geometry_columns table with the user I'm loging
in as. Make sure you have given the user you're using to load the SQL
the appropriate permissions.

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Monday, June 20, 2005 2:25 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Shape File data loader


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

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