I recall having similar issues when moving to 8.3. I think I had to put in a using UNIQUE in there for some of my layers but mostly layers that were view based Try doing
DATA "geoloc from consejospopulares USING UNIQUE gid USING SRID=sridgoeshere" Or DATA "geoloc from consejospopulares USING UNIQUE gid" Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fsalas Sent: Tuesday, August 26, 2008 6:07 PM To: David Fawcett; [email protected] Subject: Re: [postgis-users] problem with OIDS Hi ,David I Have mapserver 5.2.0 This is my map file: #Start of layer definitions LAYER NAME "consejospopulares" GROUP "Mapa" STATUS ON DATA "geoloc from consejospopulares" TYPE POINT CONNECTIONTYPE POSTGIS CONNECTION "dbname=prueba user=salas password=salas host=localhost" SYMBOLSCALE 2000 TOLERANCE 3 CLASS NAME "consejospopulares" TEMPLATE "query.phtml" STYLE SYMBOL "icon4" COLOR 254 000 000 OUTLINECOLOR 0 0 0 MINSIZE 5 MAXSIZE 20 END END END END Best Regards,Salas ----- Original Message ----- From: "David Fawcett" <[EMAIL PROTECTED]> To: "fsalas" <[EMAIL PROTECTED]>; "PostGIS Users Discussion" <[email protected]> Cc: "Obe, Regina" <[EMAIL PROTECTED]> Sent: Tuesday, August 26, 2008 2:36 PM Subject: Re: [postgis-users] problem with OIDS >I am guessing that you are using ms4w 2.2.8, which would put your > MapServer version at 5.x. > > I haven't used MapLab, does it build and write map files to the > filesystem? If so, can you share the text of your map file, > specifically, the layer definition for consejospopulares? My > assumption is that you need to modify the query in your data > statement. > > David. > > On Tue, Aug 26, 2008 at 2:29 PM, fsalas <[EMAIL PROTECTED]> wrote: >> Hi, Regina, >> >> I have postgreesql 8.3 with postgis_1_3_3_pg83.exe and mapserver 2.2.8 >> >> This is the message of the Maplab when i try to browse the map File. >> >> Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named >> 'consejospopulares'. in >> C:\ms4w\apps\maplab-2.2\htdocs\mapedit\preview.php >> on line 469 >> >> Warning: [MapServer Error]: prepare_database(): Error declaring cursor: >> ERROR: column "oid" does not exist LINE 1: >> ...sbinary(force_collection(force_2d(geoloc)),'NDR'),OID::text ... ^ With >> query string: DECLARE mycursor BINARY CURSOR FOR SELECT >> asbinary(force_collection(force_2d(geoloc)),'NDR'),OID::text from >> consejospopulares WHERE geoloc && setSRID('BOX3D(214616.053511706 >> 284600,230683.946488294 295300)'::BOX3D, >> find_srid('','consejospopulares','geoloc') ) in >> C:\ms4w\apps\maplab-2.2\htdocs\mapedit\preview.php on line 469 >> >> can you Tell me , How I can resolve this situation? >> >> Best Regards,Salas >> >> ----- Original Message ----- >> >> From: Obe, Regina >> To: fsalas ; PostGIS Users Discussion >> Sent: Tuesday, August 26, 2008 9:29 AM >> Subject: RE: [postgis-users] problem with OIDS >> OIDS=true is obsolete because it has limitations on size and PostgreSQL >> in >> general has been trying to get people to stop using it for general user >> tables. Mapserver works fine for me without it and uses the gid field. >> >> What sort of problem are you having? Could be a completely different >> issue >> or you are running a really old version of mapserver. >> >> Hope that helps, >> Regina >> ________________________________ >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> fsalas >> Sent: Tuesday, August 26, 2008 9:04 AM >> To: [email protected] >> Subject: [postgis-users] problem with OIDS >> >> Hi, >> >> in this moment I have problems with mapserver and postgis. >> >> This is the sentence create with shp2pgsql.exe why set the >> >> WITH (OIDS=FALSE)?; >> >> How I can change this to OIDS=TRUE >> >> CREATE TABLE areasalud >> ( >> gid serial NOT NULL, >> codasalud bigint, >> "version" bigint, >> descasalud character varying(40), >> geoloc geometry, >> CONSTRAINT areasalud_pkey PRIMARY KEY (gid), >> CONSTRAINT enforce_dims_geoloc CHECK (ndims(geoloc) = 2), >> CONSTRAINT enforce_geotype_geoloc CHECK (geometrytype(geoloc) = >> 'MULTIPOLYGON'::text OR geoloc IS NULL), >> CONSTRAINT enforce_srid_geoloc CHECK (srid(geoloc) = 2085) >> ) >> WITH (OIDS=TRUE); >> ALTER TABLE areasalud OWNER TO postgres; >> >> >> bets regards >> >> Salas >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > ___________________________________ Dpto de Sistemas Informáticos Oficina Central Grupo Empresarial GEOCUBA Este mensaje esta libre de virus. Revisado por Kaspersky Antivirus ---------------------------------------------------------------------- Engine version: 4.0.1.14 Engine date: 2002/06/25 Definition count: 1022653 Definition date: 2008/08/26 MDAV version: 2.2.9 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
