[QGIS-trac] [Quantum GIS] #1107: Mapfile export - DATA parameter
does not work for the case sensitive PostGIG table names
Quantum GIS
qgis at qgis.org
Fri May 23 17:37:35 EDT 2008
#1107: Mapfile export - DATA parameter does not work for the case sensitive
PostGIG table names
---------------------------------------------------------+------------------
Reporter: str238 | Owner: nobody
Type: bug | Status: new
Priority: critical: causes crash or data corruption | Milestone: Version 1.0
Component: MapServer export | Version: HEAD
Keywords: | Platform_version:
Platform: All | Must_fix: No
Status_info: 0 |
---------------------------------------------------------+------------------
The DATA parameter is incorrectly written into the mapfile when PostGIS
layer used. There are no double quotation used for the table name and that
is why the case sensitive table names in PostGIS database are not found.
{{{
DATA 'the_geom FROM public.CN_2007_orez'
}}}
should be like (schema and geometry column name can be case sensitive as
well)
{{{
DATA '"the_geom" FROM "public"."CN_2007_orez"'
}}}
--
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1107>
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