[GRASS5] [bug #3623] (grass) v.in.ogr fails when input contains a column 'CAT'

[Hamish]

> this bug's URL: http://intevation.de/rt/webrt?serial_num=3623
> ---------------------------------------------------------------------
> 
> Subject: v.in.ogr fails when input contains a column 'CAT'

> GRASS Version: cvs 23.08.05
> 
> details:
> 
> GRASS 6.1.cvs (caves_utm33):~ > v.in.ogr
> dsn=/home/trawiarz/poz_fault_patch_cut_pt_extr/poz_fault_patch_cut_pt
> _extr.shp output=poz_fault_patch_cut_pt_extr_re
> layer=poz_fault_patch_cut_pt_extr min_area=0.0001 snap=-1
> A datum name wgs84 (WGS_1984) was specified without transformation
>  parameters.
> Note that the GRASS default for wgs84 is towgs84=0.000,0.000,0.000.
> Projection of input dataset and current location appear to match.
> Proceeding with import... Layer: poz_fault_patch_cut_pt_extr
> DBMI-DBF driver error:
> Column 'CAT' already exists (duplicate name)
> Cannot create table.
> Error in db_execute_immediate()
> 
> 
> GRASS_INFO_ERROR(9053,1): Cannot create table: create table
> poz_fault_patch_cut_pt_extr_re (cat integer, CAT double precision, WYS
> double precision, SM double precision, WYS_MULT double precision)

use the cnames= option to rename the column to something non-reserved,
or make CAT column of type integer if it is in fact a category column?

v.in.ogr:
    cnames   List of column names to be used instead of original names,
first is used for category column

or v.in.db depending on format of file.


Hamish