Re: [postgis-users] problem with OIDS

fsalas Tue, 26 Aug 2008 14:15:55 -0700

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'. inC:\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 PostgreSQLin

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 differentissue

or you are running a really old version of mapserver.

Hope that helps,
Regina
________________________________
From: [EMAIL PROTECTED]

[mailto:[EMAIL PROTECTED] On Behalf Offsalas

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

Re: [postgis-users] problem with OIDS

Reply via email to