Only look for pointcloud in its installed extension schema

Closes #33509
qgis · Jan 16, 2020 · 1f44b29 · 1f44b29
1 parent ab9cbe0
commit 1f44b29
Showing 1 changed file with 6 additions and 2 deletions.
diff --git a/src/providers/postgres/qgspostgresconn.cpp b/src/providers/postgres/qgspostgresconn.cpp
@@ -1103,9 +1103,13 @@ QString QgsPostgresConn::postgisVersion() const
 SELECT
  has_table_privilege(c.oid, 'select')
  AND has_table_privilege(f.oid, 'select')
-FROM pg_class c, pg_class f
-WHERE c.relname = 'pointcloud_columns'
+FROM pg_class c, pg_class f, pg_namespace n, pg_extension e
+WHERE c.relnamespace = n.oid
+  AND c.relname = 'pointcloud_columns'
+  AND f.relnamespace = n.oid
   AND f.relname = 'pointcloud_formats'
+  AND n.oid = e.extnamespace
+  AND e.extname = 'pointcloud'
     )" ), false );
     if ( result.PQntuples() >= 1 && result.PQgetvalue( 0, 0 ) == QLatin1String( "t" ) )
     {