Bug report #9135
PostGIS - materialized views only show if "also list tables with no geometry" is ticked
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||worksforme|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||17770|
PostGIS materialized views are not shown in the "Add PostGIS table" dialog UNLESS "also list tables with no geometry" is ticked, even if they have geometry columns.
Expected behaviour is that materialized views would show with "also list tables with no geometry" UNTICKED if they do have a geometry column.
#3 Updated by Jürgen Fischer over 6 years ago
Nyall Dawson wrote:
Do you have "Don't resolve type of unrestricted columns (geometry)" ticked? (I do). Perhaps this bug is only triggered when that is ticked..?
No. But that can also cause this as materialized views also don't have geometry type constraints.
#5 Updated by Jürgen Fischer almost 6 years ago
- Category set to Data Provider/PostGIS
- Status changed from Open to Feedback
Matthias Kuhn wrote:
Is this an issue that will be solved? Or maybe it needs some hints on the GUI/help side?
I can't reproduce it. I see a materialized views when "Also list tables with no geometry" is not checked - whether or not I check "Don't resolve type of unrestricted columns (geometry)" doesn't matter.