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 <[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
