Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I test to join two postgis layers, one geometryc and other without geometryc data. Data are loaded properly in qgis (1.8 in Osgeo4w distribution) and the joins seem been done properly but when i try to select data from Attribute table in layer "expanded" with the join, integer fields have a beavieur like text fiels and query results are not correct (1.9 version data are missing when do the join).

My table structure are:

 CREATE TABLE "Municipi_Dades"
 (
  "MUNICIPI" character varying(80) NOT NULL,
  "POBLACIO" bigint,
  CONSTRAINT "Primary" PRIMARY KEY ("MUNICIPI" )
 )

and

 CREATE TABLE "Municipi_Area"
 (
  gid integer NOT NULL,
  "MUNICIPI" character varying(80),
  "COMARCA" character varying(80),
  "PROVINCIA" character varying(80),
  "NOM_MUNI" character varying(80),
  "NOMN_MUNI" character varying(80),
  "NOMG_MUNI" character varying(80),
  "CAP_MUNI" character varying(80),
  "CAPN_MUNI" character varying(80),
  "CAPG_MUNI" character varying(80),
  "SUP_MUNI" double precision,
  "ORSUP_MUNI" character varying(80),
  the_geom geometry,
  CONSTRAINT "Municipi_Area_pkey" PRIMARY KEY (gid ),
  CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = (-1))
 )

I joint the two tables using field "MUNICIPI" and get problem with the field "POBLACIO" (it show as integer in schema table but query as beaviour like text)

I tested gvSIG 1.12 portable for this two tables and join work properly.

Is this a bug in Attribute table query?

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.