fix detection of spatialinx for postgres materialized views

qgis · Jan 15, 2021 · 3a90ea3 · 3a90ea3
1 parent 9e534eb
commit 3a90ea3
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresproviderconnection.cpp b/src/providers/postgres/qgspostgresproviderconnection.cpp
@@ -418,7 +418,7 @@ bool QgsPostgresProviderConnection::spatialIndexExists( const QString &schema, c
                                                                   AND i.oid=ix.indexrelid
                                                                   AND a.attrelid=t.oid
                                                                   AND a.attnum=ANY(ix.indkey)
-                                                                  AND t.relkind='r'
+                                                                  AND t.relkind IN ('r', 'm')
                                                                   AND ns.nspname=%1
                                                                   AND t.relname=%2
                                                                   AND a.attname=%3;