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

[Andy Colson]

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 <andy at squeakycode.net>
> *To:* Benoit PESTY <tchule at hotmail.com>
> *Cc:* mapserver-users at lists.osgeo.org
> *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
> mapserver-users at lists.osgeo.org <mailto:mapserver-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>