Refresh mv not working - Githubissues

kartoza / SAEOSS-Portal

The SAEOSS Portal has been proposed as a system of software components functioning together as the national central earth observation geospatial repository, with a view to metadata and open geospatial API standards compliance as well as user impact maximization

https://kartoza.github.io/SAEOSS-Portal/

GNU Affero General Public License v3.0

4 stars 9 forks source link

Refresh mv not working #207

Closed voogt closed 8 months ago

voogt commented 8 months ago

Running docker exec -ti saeoss_ckan-web_1 poetry run ckan saeoss pycsw refresh-materialized-view produces error

voogt commented 8 months ago

Steps to reproduce

When docker exec -ti saeoss_ckan-web_1 poetry run ckan saeoss pycsw create-materialized-view is run and no tags are saved within a dataset, the materialized view gets created as a table instead
This in turn produces sql error when trying to refresh

Solution

DROP TABLE saeoss_pycsw_view;
Add tags to datasets
Run docker exec -ti saeoss_ckan-web_1 poetry run ckan saeoss pycsw create-materialized-view