[GRASS-dev] [GRASS GIS] #346: v.in.ogr fails when ArcIDs list is
longer than 40 characters
GRASS GIS
trac at osgeo.org
Mon Oct 27 18:02:46 EDT 2008
#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>
More information about the grass-dev
mailing list