Is it a postgis provider problem or does it come from an invalid
table/view formating?
thanks
2010/6/2 Lionel Roubeyrie :
> 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,
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,
Hi Lionel,
try a query like this:
select count(gid) from 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
http://lists.osgeo.org/mailman/listinfo/qgis-user
