[mapguide-users] PostGIS selection bug?

[Maciej Skorczewski]

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;