On 7/9/2010 10:16 AM, Benoit PESTY wrote:
Hello,
I have a problem configuring a WFS Service.
My layer is defined like this:
LAYER
NAME " forest_plot_layer"
TYPE POLYGON
STATUS ON
METADATA
WFS_TITLE "Forest Plots"
"gml_include_items" "all"
"gml_featureid" "cell_id"
END
DUMP TRUE
CONNECTIONTYPE postgis
CONNECTION xxxxxxxxxx
DATA "the_geom FROM forest_plot_layer"
CLASS
NAME "Forest Plot"
STYLE
SIZE 3
COLOR 0 255 0
OUTLINECOLOR 0 255 0
END
END
PROJECTION
"init=epsg:3035"
END
END
And I have the follwing error :
------------------------------------------
[Tue Jul 6 18:49:16 2010].228958 msPostGISLayerGetShape(): Query error.
Error (ERROR: operator does not exist: character varying = integer LINE
1: ...l_id" from forest_plot_layer where "cell_id" = 1
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
------------------------------------------
My "forest_plot_layer" table only has a "cell_id" column which is the PK
and a "the_geom" column.
The WMS service works correctly.
Does anyone have an idea?
Thanks,
This: "gml_featureid" "cell_id"
Seems to be the culprit. I'm not sure what that does, if you dont need
it, delete it.
If you do need it, then I'd guess changing your sql to this would help:
DATA "the_geom FROM (select cell_id, the_geom from forest_plot_layer) as
subq"
... unrelated, I see you dont have "using unique" on your DATA line... I
believe it'll speed things up if you use it. (although I have never
actually tested the claim).
from: http://mapserver.org/input/vector/postgis.html
-Andy
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
