[Qgis-developer] postgis load error on 0.8

[Gavin Macaulay]

Kirk,

That indeed looks like a bug. Can you submit a bug at svn.qgis.org/trac, 
and include the SQL definition of the view in question, as well as the 
public.mn_pls_grid table?

Assign the bug to g_j_m (me).

Thanks

Gavin

Kirk R. Wythers wrote:
> 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)
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.qgis.org
> http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-developer