[Qgis-developer] postgis load error on 0.8

[Kirk R. Wythers]

I am trying to load a postgis view in a a new build of 0.8 qgis. The  
error returned complains about now column being usable as a unique  
key. The error then goes on to list the columns and give discriptions  
(very useful feature by the way). 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. Is this a bug?

Thanks,

Kirk


The view 'publicall_timber_data'has no column suitable for use as a  
unique key.

Qgis requires that the view has a column that can be used as a unique  
key. Such a column should be derived from a table column of type int4  
and be a primary key, have a unique constraint on it, or be a  
PostgreSQL oid column. To improve performance the column should also  
be indexed.

The view you selected has the following columns, none of which  
satisfy the above conditions:
'area' derives from 'public.mn_pls_grid.area' and is not suitable  
(type is numeric and does not have a suitable constraint)
'cords' derives from 'public.timber_volume.cords' and is not suitable  
(type is int4 and does not have a suitable constraint)
'county_name' derives from 'public.county.county_name' and is not  
suitable (type is varchar and does not have a suitable constraint)
'forty_name' derives from 'public.forties.forty_name' and is not  
suitable (type is varchar and does not have a suitable constraint)
'gid' derives from 'public.mn_pls_grid.gid' and is suitable.
'mbm' derives from 'public.timber_volume.mbm' and is not suitable  
(type is int4 and does not have a suitable constraint)
'perimeter' derives from 'public.mn_pls_grid.perimeter' and is not  
suitable (type is numeric and does not have a suitable constraint)
'poles' derives from 'public.timber_volume.poles' and is not suitable  
(type is int4 and does not have a suitable constraint)
'posts' derives from 'public.timber_volume.posts' and is not suitable  
(type is int4 and does not have a suitable constraint)
'range' derives from 'public.mn_pls_grid.range' and is not suitable  
(type is int2 and does not have a suitable constraint)
'rdir_name' derives from 'public.rdir.rdir_name' and is not suitable  
(type is varchar and does not have a suitable constraint)
'rdir_shortname' derives from 'public.rdir.rdir_shortname' and is not  
suitable (type is varchar and does not have a suitable constraint)
'section' derives from 'public.mn_pls_grid.section' and is not  
suitable (type is int2 and does not have a suitable constraint)
'the_geom' derives from 'public.mn_pls_grid.the_geom' and is not  
suitable (type is geometry and does not have a suitable constraint)
'township' derives from 'public.mn_pls_grid.township' and is not  
suitable (type is int2 and does not have a suitable constraint)
'tt_name' derives from 'public.timber_type.tt_name' and is not  
suitable (type is varchar and does not have a suitable constraint)
'tt_shortname' derives from 'public.timber_type.tt_shortname' and is  
not suitable (type is varchar and does not have a suitable constraint)
'year' derives from 'public.timber_volume.year' and is not suitable  
(type is varchar and does not have a suitable constraint)