Opened 16 years ago

Closed 15 years ago

Last modified 15 years ago

#1107 closed bug (fixed)

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

Reported by: str238 Owned by: gsherman
Priority: critical: causes crash or data corruption Milestone:
Component: MapServer export Version: Trunk
Keywords: Cc:
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: no

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"'

Change History (3)

comment:1 by gsherman, 16 years ago

Owner: changed from nobody to gsherman

comment:2 by jef, 15 years ago

Resolution: → fixed
Status: new → closed

fixed in r9783

comment:3 by (none), 15 years ago

Milestone: Version 1.0.0

Milestone Version 1.0.0 deleted

Note: See TracTickets for help on using tickets.