Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

remove stacked views #564

Open
smnorris opened this issue Aug 8, 2024 · 1 comment
Open

remove stacked views #564

smnorris opened this issue Aug 8, 2024 · 1 comment

Comments

@smnorris
Copy link
Owner

smnorris commented Aug 8, 2024

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 smnorris changed the title crossings_vw as table instead of materialized view? remove stacked views Aug 8, 2024
@smnorris
Copy link
Owner Author

smnorris commented Aug 8, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant