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

[Carlos Ruiz]

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
http://lists.osgeo.org/mailman/listinfo/mapserver-users



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100709/ab93ec0c/attachment.html