Missing fields from tabblock table in tiger2011 census loader

[bpanulla]

Similar to #1885, the TIGER 2011 Geocoder has some issues with the tabblock table. The loader throws the following error in the logs:

NOTICE:  INSERT INTO tiger_data.ca_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp) SELECT the_geom,intptlon,intptlat,awater,aland,funcstat,uace10,ur10,mtfcc,name,tabblock_id,suffix1ce,blockce10,tractce10,countyfp10,statefp10,countyfp,statefp FROM tiger_staging.ca_tabblock;
CONTEXT:  SQL function "loader_load_staged_data" statement 1
ERROR:  INSERT has more expressions than target columns
LINE 1: ...block_id,suffix1ce,blockce10,tractce10,countyfp10,statefp10,...

The extra fields in the staging table generated by the shapefile loader are:

        statefp CHARACTER VARYING(2),
        countyfp CHARACTER VARYING(3),
...
        suffix1ce CHARACTER VARYING(1),

The statefp and countyfp fields are accompanied by statefp10 and countyfp10, so I'm not sure which pair is actually extra.

I haven't noticed any problems with the functionality of the Geocoder.

[robe]

this doesn't seem to be an issue in 2.1. fixed for 2.0 at r10716