Bug report #13829
Updated by Jürgen Fischer about 7 years ago
In the DB Manager Manger materialized views are just named "View" (see 'General info/Relation type').
Deleting a view by 'Right Click/Delete' is not possible.
<pre>
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"
</pre>
Deleting a view by 'Right Click/Delete' is not possible.
<pre>
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"
</pre>