[Qgis-user] Doubt about postgis materialized views

Xavier Barnada xbarnada at gmail.com
Sun Mar 6 01:32:59 PST 2016


Hi,

I noticed an inconsistent behavior on Qgis 2.14 when I try to load a data
from a postgis database.
It's the following, if I load the table x I don't need any primary key, but
if I create a view or a materialized view of the table x it must have a
primary key.
I solved it adding a key field when created the view but I don't understand
why this difference.
If anyone can explain me this difference I will be grateful.

Cheers
Xavier Barnada
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160306/3fd06e55/attachment.html>


More information about the Qgis-user mailing list