Re: [Qgis-user] Re:postgis layer from a view

Hi all, thanks for your help, effectively I didn't take care about duplicated gids. To avoid this, I have changed the view to : SELECT com.gid, com.the_geom, com.region, nrj_com.* FROM (SELECT nrj.commune, sum(nrj.cha) AS cha, sum(nrj.ecs) AS ecs,

Re: [Qgis-user] Re:postgis layer from a view

Is it a postgis provider problem or does it come from an invalid table/view formating? thanks 2010/6/2 Lionel Roubeyrie lionel.roubey...@gmail.com: Hi all, thanks for your help, effectively I didn't take care about duplicated gids. To avoid this, I have changed the view to : SELECT    

[Qgis-user] Re:postgis layer from a view

Hi Lionel, try a query like this: select count(gid) from view group by gid having count(gid)1 to see if there is some duplicates. Regards, Andrea. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org