: [Qgis-user] Re:Constraints on postgresql views
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 aperi2...@gmail.com:
- Masquer le texte des
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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
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 aperi2...@gmail.com:
- Masquer le texte des messages précédents -
Perhaps,
it missing a