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