[postgis-users] PostGIS 2.02 view problem

[karsten]

Yes the view does have the gid (I did not include all the fields of the view
and stupidly forgit to t list the gid field in the email) below. I tried to
use a different colum as unique key and select it AS gid instead which did
not work (same error), then I added a new unique id using
nextval('myloc_loc_gid_seq'::regclass) AS gid (and omitted the old one), 
still same error.
what else should, itry - running  out of ideas 
 
Cheers
Karsten
 
  _____  

From: Richard Greenwood [mailto:richard.greenwood at gmail.com] 
Sent: Wednesday, July 24, 2013 07:05 AM
To: karsten at terragis.net; PostGIS Users Discussion
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS 2.02 view problem


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 <karsten at terragis.net> 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&
#39;).
 
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
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users






-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130724/bc693ad6/attachment-0001.html>