Bug report #1107
Mapfile export - DATA parameter does not work for the case sensitive PostGIG table names
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Low | ||
| Assignee: |  Gary Sherman | ||
| Category: | - | ||
| Affected QGIS version: | Regression?: | No | |
| Operating System: | All | Easy fix?: | No |
| Pull Request or Patch supplied: | Resolution: | fixed | |
| Crashes QGIS or corrupts data: | Copied to github as #: | 11167 |
Description
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"'
Associated revisions
use QgsDataSourceURI to parse postgres connection string in mapserver export (fixes #1107)
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@9783 c8812cc2-4d05-0410-92ff-de0c093fc19c
use QgsDataSourceURI to parse postgres connection string in mapserver export (fixes #1107)
git-svn-id: http://svn.osgeo.org/qgis/trunk@9783 c8812cc2-4d05-0410-92ff-de0c093fc19c
History
#1
Updated by Jürgen Fischer over 15 years ago
- Resolution set to fixed
- Status changed from Open to Closed
fixed in
#2 Updated by Anonymous over 14 years ago
Milestone Version 1.0.0 deleted