Feature request #9127

DBManager should show Postgres materialized views

Added by Nyall Dawson over 10 years ago. Updated over 10 years ago.

Category:DB Manager
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:17764


Postgres 9.3 added support for materialized views. These are currently ignored by dbmanager and not shown in the tree alongside the other tables/views.

Related issues

Related to QGIS Application - Feature request #8791: Support PostgreSQL materialized views Closed 2013-10-07
Related to QGIS Application - Bug report #9136: Browser does not show Postgres materialized views Closed 2013-11-27

Associated revisions

Revision a4c365c7
Added by Jürgen Fischer over 10 years ago

dbmanager: include materialized views (implements #9127)


#1 Updated by Lee Hachadoorian over 10 years ago

Materialized views don't appear in geometry_columns, but this is a fault of PostGIS. When PostGIS gets fixed, would this problem go away?

See http://gis.stackexchange.com/questions/74588/materialized-view-does-not-appear-in-geometry-columns-view

#2 Updated by Jürgen Fischer over 10 years ago

  • Tracker changed from Bug report to Feature request

#3 Updated by Jürgen Fischer over 10 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF