[QGIS-trac] Re: [Quantum GIS] #2189: Map Server Export - POSTGIS
data
Quantum GIS
qgis at qgis.org
Sat Dec 5 09:10:11 EST 2009
#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
More information about the QGIS-trac
mailing list