[postgis-users] problem with OIDS

fsalas fsalas at geocuba.cu
Tue Aug 26 12:29:08 PDT 2008


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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of fsalas
  Sent: Tuesday, August 26, 2008 9:04 AM
  To: postgis-users at postgis.refractions.net
  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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080826/78094589/attachment.html>


More information about the postgis-users mailing list