[postgis-users] shp2pgsql error - current transaction is aborted...

Andy Colson andy at squeakycode.net
Thu Dec 1 06:56:59 PST 2011


On 12/1/2011 8:04 AM, jdmorgan wrote:
> Hello,
>
> I am attempting utilizing the shp2pgsql utility to import a
> shapefile.The utility reports that the shapefile is of the type
> MULTIPOLYGON[2] and then proceeds to through a bunch of errors for each
> record that it can’t import “current transaction is aborted, commands
> ignored until end of transaction block”.Any advice on how to get around
> this would be greatly appreciated.
>
> Sincerely,
>
> -- JDM @ NEMAC

If you are using -S  (capital S) (Generate simple geometries instead of 
MULTI geometries) then that would be a problem.

Showing us your command might help.

-Andy




More information about the postgis-users mailing list