search

mapcentia / geocloud2

The GC2 framework helps you build a spatial data infrastructure quickly and easily. Powered using open source components for a scalable solution focused on freedom rather than fees.
https://www.osgeo.org/projects/gc2-vidi/
GNU Affero General Public License v3.0
148 stars 67 forks source link

Load table structure from Materialized view #25

Closed baffioso closed 8 years ago

baffioso commented 8 years ago

I get the message "Could not load table structure" when selecting a materialized view in the Database tab. Is it possible to get this information?

mapcentia commented 8 years ago

Column introspecting is done with information_schema.columns, which is SQL standard and therefore not comprises not standard Materialized views. An idea is to switch the column introspecting for Materialized views to the catalog tables.

mapcentia commented 8 years ago

Column introspecting is now done in the catalog tables, so GC2 fully supports materialized views (both with and without geometry columns). Then creating a view from Admin, the option of creating as materialized is added. In Database grid and Map layertree each layer are now shown with a color code for neither Table, Foreign table, View or Materialized view.