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

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: Igor Katson <descentspb(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I look at a recursive table dependency tree?
Date: 2009-01-19 14:36:07
Message-ID: 92869e660901190636hc9de4baqf8b2a1d3292a35b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/1/19 Igor Katson <descentspb(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-01-19 14:40:04 Re: How can I look at a recursive table dependency tree?
Previous Message Ivan Sergio Borgonovo 2009-01-19 14:30:15 Re: How can I look at a recursive table dependency tree?