[fdo-trac] #119: PostGIS missing quotes for columns in queries

[FDO]

#119: PostGIS missing quotes for columns in queries
------------------------------+---------------------------------------------
 Reporter:  jbirch            |         Owner:  mloskot 
     Type:  defect            |        Status:  assigned
 Priority:  major             |     Milestone:  3.4.0   
Component:  PostGIS Provider  |       Version:  3.2.2   
 Severity:  3                 |    Resolution:          
 Keywords:  quoting           |   External_id:          
------------------------------+---------------------------------------------
Changes (by mloskot):

  * keywords:  => quoting
 * cc: riccardo.vignotto at comune.jesolo.ve.it (added)

Comment:

 Recently, Riccardo Vignotto has reported similar problems when using FDO
 PostGIS provider from GEOMAP GROUP website (http://www.geomapgis.com/web/
 geomap-group/fdo/index.html):

    ''I see that if you query like this 'SELECT colUMN FROM TaBLe' postgre
 convert the query to 'SELECT column FROM table'. But if you use double
 quotes like this 'SELECT "colUMN" FROM "TaBLe"' it does not lower the case
 of characters. From log files I see that you don’t use double quotes when
 querying the db. So this is my suggestion for the next versions of the FDO
 provider that you develop.''

 I've asked Riccardo to check if he uses a patched version (r3318) of the
 provider.

 Riccardo, I've added your email to CC of this ticket to keep you notified
 about news. I hope you don't mind.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/119#comment:3>
FDO <http://fdo.osgeo.org/>
Feature Data Objects