[postgis-users] QGIS requires
toni-10
fiorenontaglio at libero.it
Sat Jul 9 07:14:44 PDT 2011
check out this workaround, should work:
https://sites.google.com/a/fregoli.it/antonio/postgis
Ivan Mincik wrote:
>
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
--
View this message in context: http://old.nabble.com/QGIS-requires-tp29474166p32027660.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users
mailing list