Fixes DB manager queries with duplicated field names

Fixes #36205
qgis · May 29, 2020 · c8eee70 · c8eee70
1 parent da21127
commit c8eee70
Showing 1 changed file with 5 additions and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -1149,7 +1149,11 @@ bool QgsPostgresProvider::loadFields()
     if ( fields.contains( fieldName ) )
     {
       QgsMessageLog::logMessage( tr( "Duplicate field %1 found\n" ).arg( fieldName ), tr( "PostGIS" ) );
-      return false;
+      // In case of read-only query layers we can safely ignore the issue
+      if ( ! mIsQuery )
+      {
+        return false;
+      }
     }
 
     fields << fieldName;