[mapserver-users] WFS Error "column = 1" on msPostGISLayerGetShape

[Andy Colson]

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