Bug report #13829

DB Manager - "Materialized view" issues

Added by Paul Kanelli over 8 years ago. Updated over 6 years ago.

Assignee:Sebastian Dietrich
Category:DB Manager
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. 

DROP VIEW "public"."materialized_view_xy" 

Related issues

Related to QGIS Application - Feature request #13697: Add "Refresh materialized view" action in DB Manager Closed 2015-10-28
Duplicated by QGIS Application - Bug report #14020: DB Manager and Browser cannot delete materialized views Closed 2015-12-20

Associated revisions

Revision 50878114
Added by Sebastian Dietrich about 8 years ago

[DbManager] fetch type of view (materialized or not) and show in info
(refs #13829)

Revision 56000784
Added by Sebastian Dietrich about 8 years ago

[DbManager] allow to delete materialized views
(refs #13829)


#1 Updated by Giovanni Manghi over 8 years ago

  • Category set to DB Manager
  • Operating System deleted (Ubuntu)
  • OS version deleted (14.04)

#2 Updated by Médéric RIBREUX over 8 years ago


does this bug is for an Oracle DB or a PostgreSQL one ?

#3 Updated by Paul Kanelli over 8 years ago

PostgreSQL/PostGIS, I don't have Oracle in the DB Manager (Ubuntu).

#4 Updated by Paul Kanelli about 8 years ago

  • Target version set to Version 2.14

#5 Updated by Sebastian Dietrich about 8 years ago

  • Assignee set to Sebastian Dietrich
  • Status changed from Open to In Progress

#6 Updated by Sebastian Dietrich about 8 years ago

  • Affected QGIS version changed from 2.12.0 to master

#7 Updated by Sebastian Dietrich about 8 years ago

  • % Done changed from 0 to 100
  • Pull Request or Patch supplied changed from No to Yes

For a solution see PR 2714.

#8 Updated by Giuseppe Sucameli about 8 years ago

  • Status changed from In Progress to Closed
  • Resolution set to fixed/implemented

Fixed in changeset 560007846a. Many thanks for the patch!

#9 Updated by Jürgen Fischer over 6 years ago

  • Subject changed from DB Manager - "Materialised view" issues to DB Manager - "Materialized view" issues
  • Description updated (diff)

Also available in: Atom PDF