<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Thanks for the answers,<div><br></div><div>Apparently removing the "gml_featureid" "cell_id" line doesn't change anything. I suppose that the PK is detected and used.</div><div><br></div><div>I have solved the problem by adding "USING UNIQUE oid".</div><div><br></div><div>Thanks,<br><br><br><br>> Date: Fri, 9 Jul 2010 11:19:48 -0500<br>> From: andy@squeakycode.net<br>> To: boolean10001@yahoo.com<br>> CC: tchule@hotmail.com; mapserver-users@lists.osgeo.org<br>> Subject: Re: [mapserver-users] WFS Error "column = 1" on msPostGISLayerGetShape<br>> <br>> Oh... Yeah... I should pay more attention to the actual message:<br>> <br>> > HINT: No operator matches the given name and argument type(s). You might<br>> > need to add explicit type casts.<br>> <br>> This was not a "field not found" message, I fixed the wrong thing.. <br>> oops. Good catch Carlos.<br>> <br>> -Andy<br>> <br>> <br>> <br>> On 7/9/2010 11:15 AM, Carlos Ruiz wrote:<br>> > The cell_id column is of the integer type ? or character varying type ?<br>> > It must be integer to be able to<br>> > compare.<br>> ><br>> > IC Carlos Ruiz<br>> ><br>> > ------------------------------------------------------------------------<br>> > *From:* Andy Colson <andy@squeakycode.net><br>> > *To:* Benoit PESTY <tchule@hotmail.com><br>> > *Cc:* mapserver-users@lists.osgeo.org<br>> > *Sent:* Fri, July 9, 2010 10:23:39 AM<br>> > *Subject:* Re: [mapserver-users] WFS Error "column = 1" on<br>> > msPostGISLayerGetShape<br>> ><br>> > On 7/9/2010 10:16 AM, Benoit PESTY wrote:<br>> > > Hello,<br>> > ><br>> > > I have a problem configuring a WFS Service.<br>> > ><br>> > > My layer is defined like this:<br>> > ><br>> > > LAYER<br>> > > NAME " forest_plot_layer"<br>> > > TYPE POLYGON<br>> > > STATUS ON<br>> > > METADATA<br>> > > WFS_TITLE "Forest Plots"<br>> > > "gml_include_items" "all"<br>> > > "gml_featureid" "cell_id"<br>> > > END<br>> > > DUMP TRUE<br>> > > CONNECTIONTYPE postgis<br>> > > CONNECTION xxxxxxxxxx<br>> > > DATA "the_geom FROM forest_plot_layer"<br>> > > CLASS<br>> > > NAME "Forest Plot"<br>> > > STYLE<br>> > > SIZE 3<br>> > > COLOR 0 255 0<br>> > > OUTLINECOLOR 0 255 0<br>> > > END<br>> > > END<br>> > > PROJECTION<br>> > > "init=epsg:3035"<br>> > > END<br>> > > END<br>> > ><br>> > ><br>> > > And I have the follwing error :<br>> > > ------------------------------------------<br>> > > [Tue Jul 6 18:49:16 2010].228958 msPostGISLayerGetShape(): Query error.<br>> > > Error (ERROR: operator does not exist: character varying = integer LINE<br>> > > 1: ...l_id" from forest_plot_layer where "cell_id" = 1<br>> > > ^<br>> > > HINT: No operator matches the given name and argument type(s). You might<br>> > > need to add explicit type casts.<br>> > > ------------------------------------------<br>> > ><br>> > > My "forest_plot_layer" table only has a "cell_id" column which is the PK<br>> > > and a "the_geom" column.<br>> > ><br>> > > The WMS service works correctly.<br>> > ><br>> > > Does anyone have an idea?<br>> > ><br>> > > Thanks,<br>> ><br>> > This: "gml_featureid" "cell_id"<br>> ><br>> > Seems to be the culprit. I'm not sure what that does, if you dont need<br>> > it, delete it.<br>> ><br>> > If you do need it, then I'd guess changing your sql to this would help:<br>> ><br>> ><br>> > DATA "the_geom FROM (select cell_id, the_geom from forest_plot_layer) as<br>> > subq"<br>> ><br>> > ... unrelated, I see you dont have "using unique" on your DATA line... I<br>> > believe it'll speed things up if you use it. (although I have never<br>> > actually tested the claim).<br>> ><br>> > from: http://mapserver.org/input/vector/postgis.html<br>> ><br>> > -Andy<br>> ><br>> > _______________________________________________<br>> > mapserver-users mailing list<br>> > mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org><br>> > http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>> ><br>> <br></div> <br /><hr />The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. <a href='http://www.windowslive.com/campaign/thenewbusy?tile=multiaccount&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4' target='_new'>Get busy.</a></body>
</html>