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
