You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
smnorris
changed the title
crossings_vw as table instead of materialized view?
remove stacked views
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
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?
The text was updated successfully, but these errors were encountered: