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 "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 > -- Lionel Roubeyrie lionel.roubey...@gmail.com http://youarealegend.blogspot.com _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user