[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