Hi, I have apostgis table that I can load in qgis but I can't with gvSig. In gvSig the Geometry field list box is empty so I can not complete the GeoBD wizard. I tried with other tables and it works. Maybe the way I created this table is not correct. Here is what I did: in the sql below ad2001 is a table with a geometry field visible in gvSig defavorisation2001 is a table without geometry I made a join from these 2 tables. Do you something wrong in the creation of this new table? thanks, steve
select distinct a.gid, a.the_geom, b."ADIDU", b."QUINTMAT", b."QUINTSOC" into lim_admin.IndiceDefavorisation from lim_admin.ad2001 as a, lim_admin. defavorisation2001 as b where a."dauid" = b."ADIDU"; alter table lim_admin.IndiceDefavorisation add CONSTRAINT IndiceDefavorisation_pkey PRIMARY KEY (gid), --add column idUnique serial PRIMARY KEY, add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2), add CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL), add CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326); CREATE INDEX IndiceDefavorisation_the_geom_gist ON lim_admin.IndiceDefavorisation USING gist (the_geom); -- View this message in context: http://www.nabble.com/geometry-field-doesn%27t-show-up-in-gvSig-tp20264514p20264514.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
