Hi, Actually we are coping with similar issues over here. We have a database with a central table containing location-specific measurements. This table will only grow in time, and an INT4 primary key might not fit it all in the long term. There's actually a bug report related to this specific problem: https://trac.osgeo.org/qgis/ticket/62 There seems to be an unapplied patch attached to this. 64bit systems are quite common these days, so it may be worthwhile to look into that?
Another similar issue are tables with composite primary keys. As far as I can see, QGis can't handle these... or are there workarounds for this type of problem? Anyway, glad to see this issue coming up. Arnout -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Lionel Roubeyrie Sent: vrijdag 2 april 2010 20:19 To: qgis-user Subject: [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 <[email protected]>: - 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > -- Lionel Roubeyrie [email protected] http://youarealegend.blogspot.com _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user Uniting expertise from different fields of technology in a pleasant and stimulating environment enhances innovation and the development of novel methods for sustainable production. Have a look at the international congress 'Innovation for Sustainable Production 2010' April, 18-21, 2010 - Bruges (Belgium) http://www.i-sup2010.org --- This e-mail, any attachments and the information it contains are confidential and meant only for the use of the addressee(s) only. Access to this e-mail by anyone other than the addressee(s) is unauthorized. If you are not the intended addressee (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message and notify the sender immediately. If you have received this e-mail in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. All reasonable precautions have been taken to ensure no viruses are present in this e-mail and its attachments. As our company cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
