2009/1/19 Igor Katson <descent...@gmail.com> > 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