[postgis-users] QGIS requires

[Paul Ramsey]

If this isn't a ticket for qgis, it should be. They should be able to do readonly access to tables and views that do not have unique keys, no excuses.

P.

On 2010-08-18, at 10:51 AM, William Furnass <will at thearete.co.uk> wrote:

> Hi,
> 
> QGIS requires that all PostGIS tables/views have a numeric primary
> key.  As a result I have had to create many temporary tables solely
> for the purpose of viewing the results of queries when ideally I would
> have liked to create views from the majority of my queries.  Does
> anyone know if I can create on-the-fly a serial numeric column in
> queries/views to save me having to create so many temporary tables?
> It'd be grand if something like the following were possible:
> 
> CREATE VIEW my_view AS (SELECT numeric_id_generator(),
> St_Union(wkb_geometry) FROM my_subregions GROUP BY region_id);
> 
> Cheers,
> 
> Will
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users