Re: How can I look at a recursive table dependency tree?

[Filip Rembiałkowski <plk.zuber@xxxxxxxxx>]

2009/1/19 Igor Katson <descentspb@xxxxxxxxx>

I want to DROP CASCADE a table, but I am afraid that amoung numerous recursive dependencies there will be smth, that I don't want to drop.

Is there a way to watch all dependencies recursively without doing a drop?

you could query the pg_depend system catalog:
http://www.postgresql.org/docs/8.3/static/catalog-pg-depend.html

but regarding recursive queries, you have to wait for 8.4 :)

-- 
Filip Rembiałkowski