troubleshooting
Why doesn't the "cascade" work as expected when dropping a view in RW?
I tried to drop a view using drop view accounts cascade; but received an error about other relations depending on it. Why is this happening?
Ra
Ralph Matthias Debusmann
Asked on May 25, 2023
- When dropping a view in RW using
cascade, it will only drop the view itself if there are no other dependent relations. - In this case, the error occurred because there were other materialized views depending on the view
accountsthat you were trying to drop. - To successfully drop the view, you need to first drop the downstream materialized views that depend on it.
May 25, 2023Edited by