<!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 bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi, Regina,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have <FONT face="Times New Roman"
size=3>postgreesql 8.3 with postgis_1_3_3_pg83.exe and mapserver
2.2.8</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This is the message of the Maplab when i try to
browse the map File.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><FONT size=3><FONT
face="Times New Roman"><STRONG>Warning</STRONG>: [MapServer Error]: msDrawMap():
Failed to draw layer named 'consejospopulares'. in
<B>C:\ms4w\apps\maplab-2.2\htdocs\mapedit\preview.php</B> on line
<B>469</B><BR><BR><B>Warning</B>: [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
<B>C:\ms4w\apps\maplab-2.2\htdocs\mapedit\preview.php</B> on line
<B>469</B></FONT></FONT><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT size=2>
<P>can you Tell me , How I can resolve this situation?</P></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2><FONT size=2>
<P>Best Regards,Salas</P></FONT></FONT></DIV></FONT><FONT face=Arial
size=2></DIV></FONT>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=robe.dnd@cityofboston.gov
href="mailto:robe.dnd@cityofboston.gov">Obe, Regina</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=fsalas@geocuba.cu
href="mailto:fsalas@geocuba.cu">fsalas</A> ; <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 26, 2008 9:29
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [postgis-users] problem with
OIDS</DIV>
<DIV><FONT face=Arial size=2></FONT><BR></DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2>What sort of problem are you having? Could be a
completely different issue or you are running a really old version of
mapserver.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=273424412-26082008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> <A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>fsalas<BR><B>Sent:</B> Tuesday, August 26, 2008 9:04 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
problem with OIDS<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2><FONT size=2>
<P>Hi, </P>
<P>in this moment I have problems with mapserver and postgis.</FONT><FONT
face="Times New Roman"><FONT size=3> </FONT></P></FONT><FONT size=2>
<P>This is the sentence create with shp2pgsql.exe why set the </FONT><FONT
face="Times New Roman"><FONT size=3>WITH (OIDS=FALSE)?;</FONT></P>
<P>How I can change this to OIDS=TRUE</P></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2>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) = '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;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>bets regards </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Salas</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT color=#339900 size=2>
<P><FONT face=Arial color=#000000></FONT></FONT></P></BLOCKQUOTE></BODY></HTML>