v.in.ogr fails when ArcIDs list is longer than 40 characters

[dmahoney]

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', '', '', '',
       '' )

[dmahoney]

Patch to fix ArcID string length issue

[neteler]

Note for devs:

cd grass64/vector/v.in.ogr/
grep 40 *
main.c:    int OFTIntegerListlength = 40;       /* hack due to limitation in OGR */

The attached patch seems to address this hack.

Markus

[neteler]

Is this a reasonable patch? Feedback from power users desired...

[martinl]

Replying to neteler:

Is this a reasonable patch? Feedback from power users desired...

seems to be reasonable patch for me.

[neteler]

OFTIntegerListlength enlarged in trunk in r65133