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

Benoit PESTY tchule at hotmail.com
Fri Jul 9 08:16:29 PDT 2010


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"    ENDEND

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,


 		 	   		  
_________________________________________________________________
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100709/5c507894/attachment.htm>


More information about the MapServer-users mailing list