I tried that. I get the following error:
loadLayer(): Unknown identifier. Parsing error near (Area):(line 30)
Mapserver doesn't appear to like the additional formatting.
Do I need to recompile with system regex I wonder....?
Peter
Adam Eskreis wrote:
You could try regex
\"Area\"
-Adam
On Wed, May 27, 2009 at 6:48 PM, Peter Willis <[email protected]
<mailto:[email protected]>> wrote:
Hello,
I am having a problem serving a PostGIS layer via mapserver
as WFS.
The problem arises from the generation/use of column names
in PostgreSQL that require double quotes.
ie:
SELECT oid,gid, the_geom, "Area","Perimeter","PixelValue" FROM
global_Land_poly WHERE "PixelValue"=1;
In the map file the 'DATA' member of the PostGIS layer is defined as:
DATA "the_geom from (select oid,gid, the_geom,
Area,Perimeter,PixelValue FROM global_Land_poly WHERE PixelValue=1 )
AS FOO using SRID=4326"
<ERR>Mapserver relays a PostGIS error from PostgreSQL:
'ERROR: column "area" does not exist...</ERR>
This is because the column name is actually "Area"
and requires quotes.
How do I define double quotes in my PostGIS query
within the 'DATA' element of my mapfile layer?
Thanks for any enlightenment,
Peter
_______________________________________________
mapserver-users mailing list
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
