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

[Lionel Roubeyrie]

Is it a postgis provider problem or does it come from an invalid
table/view formating?
thanks

2010/6/2 Lionel Roubeyrie <lionel.roubeyrie at 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
>    com.gid,
>    com.the_geom,
>    com.region,
>    nrj_com.*
> FROM
>    (SELECT
>        nrj.commune,
>        sum(nrj.cha) AS cha,
>        sum(nrj.ecs) AS ecs,
>        sum(nrj.cui) AS cui,
>        sum(nrj.spe) AS spe,
>        sum(nrj.total) AS total
>    FROM residentiel.nrj_sourcesfixes nrj
>    GROUP BY nrj.commune
>    ) AS nrj_com
> JOIN spatial.commune com ON nrj_com.commune::text = com.code_insee::text;
>
> where "select count(gid) from <view> group by gid having count(gid)>1"
> returns nothing.
> However, QGIS complains again about not finding uniques int4 values,
> but performing a CREATE TABLE table AS <query_creating_view> is
> perfectly displayed in QGIS!!!!
>
> Cheers
>
> 2010/6/1 Andrea Peri 2007 <aperi2007 at gmail.com>:
>> 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 at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
>
> --
> Lionel Roubeyrie
> lionel.roubeyrie at gmail.com
> http://youarealegend.blogspot.com
>



-- 
Lionel Roubeyrie
lionel.roubeyrie at gmail.com
http://youarealegend.blogspot.com