<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<div>Hello,</div><div><br></div><div>I have a problem configuring a WFS Service.</div><div><br></div><div>My layer is defined like this:</div><div><br></div><div>LAYER</div><div> NAME " forest_plot_layer"</div><div> TYPE POLYGON</div><div> STATUS ON</div><div> </div><div> METADATA</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>WFS_TITLE<span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span> "Forest Plots"</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>"gml_include_items" <span class="Apple-tab-span" style="white-space:pre"> </span>"all"</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>"gml_featureid" <span class="Apple-tab-span" style="white-space:pre"> </span>"cell_id" </div><div> END</div><div> DUMP TRUE</div><div> </div><div> CONNECTIONTYPE postgis</div><div> CONNECTION xxxxxxxxxx</div><div> DATA "the_geom FROM forest_plot_layer" </div><div> CLASS</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>NAME "Forest Plot"</div><div> STYLE</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>SIZE 3</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>COLOR 0 255 0</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>OUTLINECOLOR 0 255 0</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>END</div><div> END</div><div> PROJECTION</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> "init=epsg:3035"</div><div> END</div><div>END</div><div><br></div><div><br></div><div>And I have the follwing error :</div><div>------------------------------------------</div><div>[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</div><div> ^</div><div>HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.</div><div>------------------------------------------</div><div><br></div><div>My "forest_plot_layer" table only has a "cell_id" column which is the PK and a "the_geom" column.</div><div><br></div><div>The WMS service works correctly.</div><div><br></div><div>Does anyone have an idea?</div><div><br></div><div>Thanks,</div><div><br></div><br><br> <br /><hr />Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. <a href='http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1' target='_new'>Learn more.</a></body>
</html>