[Qgis-user] Re:Constraints on postgresql views

[Lionel Roubeyrie]

No, it's why I have added a max(f.id) just for the test. After some
search, QGIS absolutely needs a int4 primary key, but doesn't explain
why in a table it's ok, not in a view...

2010/4/2 Andrea Peri 2007 <aperi2007 at gmail.com>:
- Masquer le texte des messages précédents -
> Perhaps,
> it missing a "group by" operator ?
>
> SELECT          f.id AS oid,    ST_Multi(ST_Union(f.the_geom)) as the_geom
> FROM (
>        SELECT          id,
>                ST_Dump(the_geom)).geom As the_geom     FROM            v_tmp
> ) As f
> group by
>        f.id
>
>
> 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