id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,must_fix,platform,platform_version,status_info 143,postgis view load error,kwythers@…,g_j_m,"I am trying to load a postgis view in a a new build of 0.8 qgis. The error complains about now column being usable as a unique key. The error then goes on to list the columns and give discriptions. However, there is a column in the view that is unique, and the error message declares that it is suitable. The column is 'gid' and is reported in the error message a suitable. Here are the discriptions of the the database as well as the ""mn_pls_grid"" table and the view ""all_timber_data"", which is returning the error. Let me know if you need any other info. Thanks. mn_timber=# \d List of relations Schema | Name | Type | Owner --------+------------------------+----------+---------- public | all_timber_data | view | kwythers public | county | table | kwythers public | forties | table | kwythers public | forties_gid_seq | sequence | kwythers public | geometry_columns | table | kwythers public | grid_cell | view | kwythers public | mn_pls_grid | table | kwythers public | rdir | table | kwythers public | session | table | kwythers public | session_session_id_seq | sequence | kwythers public | spatial_ref_sys | table | kwythers public | timber_type | table | kwythers public | timber_volume | table | kwythers public | timber_volume_seq | sequence | kwythers (14 rows) mn_timber=# \d mn_pls_grid Table ""public.mn_pls_grid"" Column | Type | Modifiers ------------+----------+------------------------------------------------------- gid | integer | not null default nextval('forties_gid_seq'::regclass) area | numeric | perimeter | numeric | pls_fort_ | bigint | pls_fort_i | bigint | county_id | smallint | township | smallint | rdir_id | smallint | range | smallint | section | smallint | forty_id | smallint | glot | smallint | parc | smallint | glotmatch | bigint | the_geom | geometry | Indexes: ""forties_pkey"" PRIMARY KEY, btree (gid) ""sidx_mn_pls_grid"" gist (the_geom) Check constraints: ""enforce_dims_the_geom"" CHECK (ndims(the_geom) = 2) ""enforce_geotype_the_geom"" CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL) ""enforce_srid_the_geom"" CHECK (srid(the_geom) = -1) Foreign-key constraints: ""mn_pls_grid_county_id_fkey"" FOREIGN KEY (county_id) REFERENCES county(county_id) ""mn_pls_grid_forty_id_fkey"" FOREIGN KEY (forty_id) REFERENCES forties(forty_id) ""mn_pls_grid_rdir_id_fkey"" FOREIGN KEY (rdir_id) REFERENCES rdir(rdir_id) mn_timber=# \d all_timber_data View ""public.all_timber_data"" Column | Type | Modifiers ----------------+-------------------+----------- gid | integer | the_geom | geometry | area | numeric | perimeter | numeric | township | smallint | range | smallint | rdir_shortname | character varying | rdir_name | character varying | section | smallint | forty_name | character varying | county_name | character varying | year | character varying | cords | integer | mbm | integer | poles | integer | posts | integer | tt_shortname | character varying | tt_name | character varying | View definition: SELECT mn_pls_grid.gid, mn_pls_grid.the_geom, mn_pls_grid.area, mn_pls_grid.perimeter, mn_pls_grid.township, mn_pls_grid.range, rdir.rdir_shortname, rdir.rdir_name, mn_pls_grid.section, forties.forty_name, county.county_name, timber_volume.""year"", timber_volume.cords, timber_volume.mbm, timber_volume.poles, timber_volume.posts, timber_type.tt_shortname, timber_type.tt_name FROM mn_pls_grid, rdir, county, forties, timber_volume, timber_type WHERE mn_pls_grid.rdir_id = rdir.rdir_id AND mn_pls_grid.county_id = county.county_id AND mn_pls_grid.forty_id = forties.forty_id AND mn_pls_grid.gid = timber_volume.grid_id AND timber_volume.tt_id = timber_type.tt_id; ",bug,closed,major: does not work as expected,,Build/Install,Trunk,fixed,,,No,OS X,10.4.6,0