[postgis-users] QGIS requires

[Mike Toews]

On 18 August 2010 11:46, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> 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.

QGIS ticket #62 is four years old now: https://trac.osgeo.org/qgis/ticket/62

As mentioned earlier, you need to engineer a sequence in there
somewhere in a low-lying table that you can use in your view as your
surrogate primary key. It can be tricky, but there is always a way to
find it.

-Mike