In your map file you have "using unique gid". Are you sure that there is a "gid" column in your view?
Rich On Wed, Jul 24, 2013 at 3:35 AM, karsten <[email protected]> wrote: > ** > Hi all, > > I am trying to use a b view in Postgis 2.0.2 ("POSTGIS="2.0.2 r10789" > GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, > released 2013/04/24" LIBXML="2.8.0" LIBJSON="UNKNOWN" TOPOLOGY RASTER") > for display via MapServer 6.2 > I am getting an this error from MapServer: > > Failed to draw layer named 'members'. > msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: > column "COUNT" does not exist > LINE 1: select > "COUNT",encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'). > > I have no idea why a count is needed here or where this field is coming > from ...seems that the regular table have no issue with this. > > My VIEW public.geometry_columns shows these values for the view: > "xy";"xy";"myloc";"geom";2;4269;"POINT" > > What can I do to fix this in Postgis ? > See below for view details > > Cheers > Karsten > > Terra GIS LTD > ------------------------- > -- View: > CREATE OR REPLACE VIEW xy.test > AS > SELECT xy.census_city_id, st_centroid(places.geom)::geometry(Point,4269) > AS geom, places.name > FROM > myschema.xy,myschema.places > > WHERE xy.census_city_id = > places.geoid::integer; > > ALTER TABLE > myschema.xy_loc > > OWNER TO myuser; > > ----------------------------------- > in mapfile: > > DATA "geom from (select * from myschema.xy) as temp using unique gid using > SRID=4269" > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > -- Richard Greenwood [email protected] www.greenwoodmap.com
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
