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

[jdmorgan]

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