[GRASS-dev] Re: [GRASS GIS] #1517: 'DateTime' not handled by v.in.ogr

[GRASS GIS]

#1517: 'DateTime' not handled by v.in.ogr
---------------------------+------------------------------------------------
  Reporter:  grasslandtom  |       Owner:  grass-dev@…                  
      Type:  defect        |      Status:  closed                       
  Priority:  normal        |   Milestone:  6.4.2                        
 Component:  Database      |     Version:  6.4.2 RCs                    
Resolution:  invalid       |    Keywords:  v.in.ogr, DateTime, TIMESTAMP
  Platform:  Unspecified   |         Cpu:  Unspecified                  
---------------------------+------------------------------------------------
Changes (by neteler):

  * status:  new => closed
  * resolution:  => invalid


Comment:

 Replying to [ticket:1517 grasslandtom]:
 ...
 > This raises the error
 > {{{
 > DBMI-DBF driver error:
 > SQL parser error: syntax error, unexpected NAME processing 'datetime'
 > in statement:
 > create table test (cat integer, datetime datetime, id integer)
 > Error in db_execute_immediate()
 > }}}

 You cannot use a reserved SQL word as column name. 'datetime' is
 reserved...

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/1517#comment:1>
GRASS GIS <http://grass.osgeo.org>