在Postgresql中删除(或替换)对象时,如果存在依赖关系,则删除将失败(不指定CASCADE).@H_404_2@

问题@H_404_2@

数据库返回的错误消息不会列出依赖对象.@H_404_2@

示例解决方案@H_404_2@

查询可能类似于：@H_404_2@

SELECT * FROM information_schema i,pg_depend pd WHERE
  i.object_id = pd.object_id AND
  i.object_type = 'TABLE' AND
  i.object_schema = 'public' AND
  i.object_name = 'table_with_dependents';

这个消失是缺失的.@H_404_2@

有关@H_404_2@

> http://postgresql.1045698.n5.nabble.com/information-schema-problem-td2144069.html
> http://www.alberton.info/postgresql_meta_info.html@H_404_2@

题@H_404_2@

如何按名称和类型生成依赖对象列表？@H_404_2@