删除视图失败，提示有其他视图依赖于该视图

2018-10-05 h2 postgresql Comments Word Count: 42words Read Count: 1minutes

问题背景

DROP VIEW temp_view;

报错信息：

Can't drop temp_view,because *** depend on it

DROP VIEW temp_view CASCADE ;

该sql会删除所有依赖的视图

Permalink: https://blog.tianshiming.com/2018/10/h2-drop-exception/

License：CC BY 4.0 CN

Finally