On 12/1/2011 9:56 AM, Andy Colson wrote:
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
Here is the command I was using shp2pgsql -s 4326
FHM_ADS_2003_4326.shp public.FHM_ADS_2003 | psql -d pgtest1 -U mbp
I have figured out the issue by looking at the SQL generated by
shp2pgsql. As it turns out there were null in a date field in the shape
file, and postgresql didn't like that for the insert statement.
Thanks,
--
JDM Morgan @ NEMAC
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users