#346: v.in.ogr fails when ArcIDs list is longer than 40 characters
-----------------------------+----------------------------------------------
Reporter: dmahoney | Owner: grass-dev@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>