Oh... Yeah... I should pay more attention to the actual message:
> HINT: No operator matches the given name and argument type(s). You might
> need to add explicit type casts.
This was not a "field not found" message, I fixed the wrong thing..
oops. Good catch Carlos.
-Andy
On 7/9/2010 11:15 AM, Carlos Ruiz wrote:
The cell_id column is of the integer type ? or character varying type ?
It must be integer to be able to
compare.
IC Carlos Ruiz
------------------------------------------------------------------------
*From:* Andy Colson <[email protected]>
*To:* Benoit PESTY <[email protected]>
*Cc:* [email protected]
*Sent:* Fri, July 9, 2010 10:23:39 AM
*Subject:* Re: [mapserver-users] WFS Error "column = 1" on
msPostGISLayerGetShape
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] <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
