Bug report #13829
DB Manager - "Materialized view" issues
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||Yes||Resolution:||fixed/implemented|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||21853|
In the DB Manager materialized views are just named "View" (see 'General info/Relation type').
Deleting a view by 'Right Click/Delete' is not possible.
Database Error An error occured when executed the query: "materialized_view_xy" is not a view HINT: Use DROP MATERIALIZED VIEW to remove a materialized view. Query: DROP VIEW "public"."materialized_view_xy"
[DbManager] fetch type of view (materialized or not) and show in info