Bug report #1107

Mapfile export - DATA parameter does not work for the case sensitive PostGIG table names

Added by str238 - over 12 years ago. Updated over 11 years ago.

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

Revision af9756e1
Added by Jürgen Fischer almost 12 years ago

use QgsDataSourceURI to parse postgres connection string in mapserver export (fixes #1107)

git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision cefa3e98
Added by Jürgen Fischer almost 12 years ago

use QgsDataSourceURI to parse postgres connection string in mapserver export (fixes #1107)

git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Jürgen Fischer almost 12 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in

#2 Updated by Anonymous over 11 years ago

Milestone Version 1.0.0 deleted

Also available in: Atom PDF