[postgis-users] shp2pgsql problem

Paul Ramsey pramsey at refractions.net
Mon Jun 16 12:45:38 PDT 2003

Step 1. Ensure you are using 0.7.5 or better. Alot of loader bugs were 
fixed in the 0.7.4 -> 0.7.5 transition.

Step 2. Edit your tmp file and remove the transaction blocks. Then try 
and load the file. Note which record fails to load. Send to us.


Heitzso wrote:
> I have a large shape file with several layers of data
> for census 2000 block level information for one state.
> This shape file is smoothly imported by current stable
> GRASS code.  I can run shp2pgsql against this shape file
> and generate the sql statements to load the data w/o an
> error being flagged.
>    $ shp2pgsql -d blk2000_ga.shp ga_blk gis >h.tmp
> The shp file is 100M, the dbf file is 160M.
> But when I attempt to load the script into the postgresql/gis
> dbms with
>    psql -f h.tmp gis
> it breaks with thousands of errors like:
>    ERROR:  current transaction is aborted,
>    queries ignored until end of transaction block
> Afterwards, within psql I '\dt;' and see the new table
> ga_blk but it is empty (has no rows).
> Because GRASS imports the data w/o a problem I assume
> the shape file is in reasonably good shape.
> Suggestions?
> Heitzso
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632

More information about the postgis-users mailing list