[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.2
Component:  tiger geocoder  |     Version:  2.0.x        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by 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);

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1838#comment:5>
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.