On 10/11/2010 01:52 PM, William Furnass wrote:
Hi,
Aman: did you test your suggestion? If you create a view from
(nextval('myseq') as id, geom, attr1, attr2) then QGIS will complain
that a layer cannot be created from that view as geom, attr1 and attr2
are not of suitable for use as a unique key (but does not even mention
the view field corresponding to the created sequence). Bah.
Unfortunately the majority of the views I'd like to be able to view in
QGIS are derived from queries involving aggregate functions such as
ST_Union so I don't think recreating my tables with OIDS will help.
If You read QGIS requirements more closely, You will find that it
requires that this column should be 'primary key, have a unique
constraint on it, or be a PostgreSQL oid column.'
I am also surprised, that sequence column is missing.
This discussion should be definitely moved to Qgis developer list. Would
You please make Your note to 'https://trac.osgeo.org/qgis/ticket/62' ?
--
Ivan Mincik, Gista s.r.o.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
