[GRASS-dev] [GRASS GIS] #578: quote column names to avoid SQL reserved word collision

[GRASS GIS]

#578: quote column names to avoid SQL reserved word collision
---------------------------+------------------------------------------------
 Reporter:  hamish         |       Owner:  grass-dev at lists.osgeo.org
     Type:  enhancement    |      Status:  new                      
 Priority:  minor          |   Milestone:  7.0.0                    
Component:  Vector         |     Version:  svn-develbranch6         
 Keywords:  v.in.ogr, SQL  |    Platform:  All                      
      Cpu:  All            |  
---------------------------+------------------------------------------------
 Hi,

 moved here from GDAL bug # 2965
 http://trac.osgeo.org/gdal/ticket/2965

 v.in.ogr will not read GPX format as input because OGR's GPX driver
 creates a DB field called "time" for the timestamp. GRASS chokes on this
 because TIME is a SQL reserved word for some backends (DBF doesn't like
 it, SQLite is ok with it).

 workaround: use the cnames= option to rename the TIME field.


 suggestion by rouault:
 "''There is no reason for the GPX driver not to use "time" as a field
 name. I think you should report it rather to the GRASS project. They
 should likely quote the field names (provided that it supports that). This
 is what the PG and MySQL driver in OGR do, so you can use any name, even
 if it is a SQL reserved keyword.''"



 comments?

 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/578>
GRASS GIS <http://grass.osgeo.org>