[Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Jürgen E. Fischer]

Hi Leknín,

On Tue, 01. Sep 2015 at 18:42:56 +0200, Leknín Řepánek wrote:
> Situation with a view without unique (and indexed) key is bad database
> model, or bad query.

Not so sure about that - you might have queries (or views) that join two or
more tables that have proper primary keys and indexed, but don't produce
a unique column of their own.

I don't think there are many assumptions you can generally make on views.

Earlier version of QGIS would deduce the primary keys of the involved tables
and offer those - but that was also nothing more than a hint of what could be
unique.



Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150901/fcedd741/attachment.sig>