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 ___________________________________ 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: 1019980 Definition date: 2008/08/26 MDAV version: 2.2.9 ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
