[Qgis-user] Re:Constraints on postgresql views

[Standaert Arnout]

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: 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
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 <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
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
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.