[GRASS-dev] DBMI parse error question

[Kirk Wythers]

Hi Markus,

I had a similar error once when I used 'data' as a field name.


Kirk

On Feb 27, 2007, at 4:38 PM, Markus Neteler wrote:

> Hi,
>
> I try to import a map from PostgreSQL into GRASS/DBF driver
> with v.in.db, but get
>
> DBMI-DBF driver error:
> SQL parser error in statement:
> create table ticks_feltre_2002_2006_sites ( ID integer, comune  
> varchar(250), localita varchar(250), microsito varchar(250), data  
> date, ora time, larve integer, ninfe integer, adm integer, adf  
> integer, adtot integer, tcelsius double precision, umidrel double  
> precision, note varchar(250), mapsheet varchar(250), mgrs varchar 
> (250), stazione varchar(250), periodo_prelievo varchar(250), north  
> double precision, east double precision, siteid integer )
> Cannot create table
>
> but I don't see where the evil is:
>
> echo " ID integer, comune varchar(250), localita varchar(250),  
> microsito varchar(250), data date, ora time, larve integer, ninfe  
> integer, adm integer, adf integer, adtot integer, tcelsius double  
> precision, umidrel double precision, note varchar(250), mapsheet  
> varchar(250), mgrs varchar(250), stazione varchar(250),  
> periodo_prelievo varchar(250), north double precision, east double  
> precision, siteid integer" | tr -s ',' '\n' | sort
>  adf integer
>  adm integer
>  adtot integer
>  comune varchar(250)
>  data date
>  east double precision
>  ID integer
>  larve integer
>  localita varchar(250)
>  mapsheet varchar(250)
>  mgrs varchar(250)
>  microsito varchar(250)
>  ninfe integer
>  north double precision
>  note varchar(250)
>  ora time
>  periodo_prelievo varchar(250)
>  siteid integer
>  stazione varchar(250)
>  tcelsius double precision
>  umidrel double precision
>
> Any ideas? Of course it would be fancy to have a more reasonable
> error message. This error uses to pop up if preserved words are used
> as column names, but I don't see any (even, it should tell me in an
> ideal world).
>
> Markus
>
> _______________________________________________
> grass-dev mailing list
> grass-dev at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass-dev