Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I look at a recursive table dependency tree? - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: How can I look at a recursive table dependency tree?
Date
Msg-id 92869e660901190636hc9de4baqf8b2a1d3292a35b@mail.gmail.com
Whole thread Raw
In response to How can I look at a recursive table dependency tree?  (Igor Katson <descentspb@gmail.com>)
List pgsql-general
Tree view


2009/1/19 Igor Katson <descentspb@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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: How can I look at a recursive table dependency tree?
Next
From: "A. Kretschmer"
Date:
Subject: Re: How can I look at a recursive table dependency tree?