#578: quote column names to avoid SQL reserved word collision
---------------------------+------------------------------------------------
Reporter: hamish | Owner: grass-dev@…
Type: enhancement | Status: new
Priority: minor | Milestone: 7.0.0
Component: Vector | Version: svn-develbranch6
Keywords: v.in.ogr, SQL | Platform: All
Cpu: All |
---------------------------+------------------------------------------------
Comment(by mlennert):
Replying to [ticket:578 hamish]:
> 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?
IMHO, quoting of field names is good practice in general, and so should be
implemented in GRASS is possible.
Moritz
--
Ticket URL: <https://trac.osgeo.org/grass/ticket/578#comment:2>
GRASS GIS <http://grass.osgeo.org>
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
