[mapguide-users] PostGIS selection bug?

[Traian Stanev]

OK good. Let me know if you have any other problems with the OGR provider.


Traian


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Maciej Skorczewski
Sent: Tuesday, February 20, 2007 4:00 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] PostGIS selection bug?

helo!

ok it's done!


when i  use shp2pgsql i get another table (whit this same shp file)


CREATE TABLE osienazwy
(
   gid serial NOT NULL,
   id bigint,
   idulicy bigint,
   ulica character varying(30),
   "pełna" character varying(100),
   id1 bigint,
   id2 bigint,
   kier2 boolean,
   length numeric,
   idodcinka bigint,
   the_geom geometry,
   CONSTRAINT osienazwy_pkey PRIMARY KEY (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 
'MULTILINESTRING'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
)
WITHOUT OIDS;
ALTER TABLE osienazwy OWNER TO postgres;



after that i edit it into this

change column name gid into ogc_fid.

...and it's work. now i can selected object form this postgis source.



CREATE TABLE osienazwy
(
   ogc_fid serial NOT NULL,
   id bigint,
   idulicy bigint,
   ulica character varying(30),
   "pełna" character varying(100),
   id1 bigint,
   id2 bigint,
   kier2 boolean,
   length numeric,
   idodcinka bigint,
   the_geom geometry,
   CONSTRAINT osienazwy_pkey PRIMARY KEY (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 
'MULTILINESTRING'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
)
WITHOUT OIDS;
ALTER TABLE osienazwy OWNER TO postgres;
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users