In PostgreSQL v9.3 with PostGIS v2.1 extensions I created a view from two tables (sites & visits). The site table contained a point geometry column (the_geom), which was included in the created view. Checking the table view it contained the expected information.
In QGIS v2.4 running under Windows 8.1, the sites table containing the geometry column can be added as a layer. However, when looking at the created view table in the DB Manager, it states:
Column: the_geom Geometry: GEOMETRY Dimension: 2 Extent: 482350.00000, 132750.00000 - 538750.00000, 177150.00000
￼ There isn't entry in geometry_columns!
The table tab shows the table contents as expected, and the preview shows the points which looks reasonable. The icon for the view table is shown as a question mark.
When the view was first created, it could not be added as a layer to the map. However, rebooting my computer has enabled the view to be added as a layer to the map.
- What does the error message mean, and how I do I get rid of it?
- Why did I need to reboot my computer to add the view table to the map?