[QGIS-trac] Re: [Quantum GIS] #2189: Map Server Export - POSTGIS data

[Quantum GIS]

#2189: Map Server Export - POSTGIS data
-----------------------------------------------------+----------------------
        Reporter:  smccabe33                         |         Owner:  rduivenvoorde
            Type:  bug                               |        Status:  assigned     
        Priority:  major: does not work as expected  |     Milestone:  Version 1.4.0
       Component:  Build/Install                     |       Version:  HEAD         
      Resolution:                                    |      Keywords:               
Platform_version:                                    |      Platform:  Debian       
        Must_fix:  No                                |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by rduivenvoorde):

  * status:  new => assigned

Comment:

 We escape all table and variable names to be safe for names using spaces
 etc ...

 BUT there is an ceveat there, see:
 http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html#
 SQL-SYNTAX-IDENTIFIERS

 Quote:
 Quoting an identifier also makes it case-sensitive, whereas unquoted names
 are always folded to lower (!) case. For example, the identifiers FOO,
 foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO"
 are different from these three and each other.

 So I reckon you have tablenames which are NOT lowercase... ?

 Should we consider this a bug?

 We could NOT quote table and variable names? We cannot test for spaces etc
 in tablenames or so, because we do not parse the data/sql ourselves.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2189#comment:3>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats