[Qgis-user] Re:Constraints on postgresql views
arnout.standaert at vito.be
Tue Apr 6 03:21:00 EDT 2010
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:
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.
From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Lionel Roubeyrie
Sent: vrijdag 2 april 2010 20:19
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 <aperi2007 at gmail.com>:
- Masquer le texte des messages précédents -
> 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
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
lionel.roubeyrie at gmail.com
Qgis-user mailing list
Qgis-user at lists.osgeo.org
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)
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.
More information about the Qgis-user