RisingWave Community - Why doesn't the "cascade" work as expected when dropping a view in RW?

troubleshooting

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?

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 accounts that 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