[postgis-devel] [PostGIS] #1838: error importing tiger/line data

[PostGIS]

#1838: error importing tiger/line data
----------------------------+-----------------------------------------------
 Reporter:  jrossi          |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.1
Component:  tiger geocoder  |     Version:  2.0.x        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1838>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.