search

smnorris / bcfishpass

Model and monitor aquatic habitat connectivity in BC. Tools to plan and prioritize the assessment and remediation of barriers.
https://smnorris.github.io/bcfishpass
Apache License 2.0
8 stars 13 forks source link

remove stacked views #564

Open smnorris opened 3 months ago

smnorris commented 3 months ago

Materialized view definitions can't be simply altered to add/remove a column of interest, the whole view must be dropped/recreated. Lots of additional views hang off of crossings_vw - adding a single column as in #559 requires a massive chain of dropping/recreating of dependent fptwg reporting views.

There must be a cleaner way to manage this?

smnorris commented 3 months ago

A materialized view for crossings_vw is fine - and useful. Updating the fptwg views to pull from the source tables is probably the best fix. Stacked views = bad