error importing tiger/line data

[jrossi]

COMMIT NOTICE: INSERT INTO tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp) SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.fl_tabblock10; CONTEXT: SQL function "loader_load_staged_data" statement 1 ERROR: INSERT has more expressions than target columns LINE 1: ...name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 ...

QUERY: INSERT INTO tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp) SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.fl_tabblock10; CONTEXT: PL/pgSQL function "loader_load_staged_data" line 24 at EXECUTE statement SQL function "loader_load_staged_data" statement 1

[robe]

Still haven't had a chance to look at this. I may just dismiss it since the reporter didn't have issue using tiger 2011 routines.

[robe]

I see the same issue on tiger 2011. Working on it now.

[robe]

Fixed for 2.1 at r10177

[robe]

correction -- r10178

[robe]

Add to this fails for California since name field is evidentally not long enough

see post: ​http://www.postgis.org/pipermail/postgis-users/2012-August/035052.html ​http://www.postgis.org/pipermail/postgis-users/2012-August/035051.html

Need to make changes

{{{ --making name bigger than it needs to be just in case

ALTER TABLE tiger.tabblock ALTER COLUMN name TYPE varychar(20);

ALTER TABLE tiger.tabblock ALTER COLUMN tabblock_id TYPE varchar(16);

}}}

[robe]

fixed at r10179 for 2.1.0 (tiger_2011) still need to backport changes to 2.0

[robe]

fixed for 2.0 at r10716