[GRASS-dev] [GRASS GIS] #346: v.in.ogr fails when ArcIDs list is longer than 40 characters

[GRASS GIS]

#346: v.in.ogr fails when ArcIDs list is longer than 40 characters
-----------------------------+----------------------------------------------
 Reporter:  dmahoney         |       Owner:  grass-dev at lists.osgeo.org
     Type:  defect           |      Status:  new                      
 Priority:  minor            |   Milestone:                           
Component:  Vector           |     Version:  svn-trunk                
 Keywords:  v.in.ogr arcids  |    Platform:  Unspecified              
      Cpu:  Unspecified      |  
-----------------------------+----------------------------------------------
 When importing from Arc/INFO coverage, OGR inserts a column called arcids
 as an integer list. It is inserted into the GRASS attribute tables as a 40
 character string field. However, some database backends do not truncate
 overly long strings, but fail instead when the record is inserted into the
 database. So some (polygon) coverages can be imported, and some can not.

 This is the error reported.
 {{{
 Importing map 7030 features...
 DBMI-Postgres driver error:
 Cannot execute:
 insert into test values ( 7029,
 '(9:13801,-13851,-13937,-14012,-14045,-13979,-13902,13856,13804)',
 809371204,       154051.26690, 7030, 6850, '', 'XX00000000', '', '', '',
 '' )
 ERROR:  value too long for type character varying(40)


 ERROR: Cannot insert new row: insert into test values ( 7029,
        '(9:13801,-13851,-13937,-14012,-14045,-13979,-13902,13856,13804)',
        809371204, 154051.26690, 7030, 6850, '', 'XX00000000', '', '', '',
        '' )

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/346>
GRASS GIS <http://grass.osgeo.org>