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

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Re: How can I look at a recursive table dependency tree?
Дата
Msg-id 92869e660901190636hc9de4baqf8b2a1d3292a35b@mail.gmail.com
обсуждение исходный текст
Ответ на How can I look at a recursive table dependency tree?  (Igor Katson <descentspb@gmail.com>)
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: How can I look at a recursive table dependency tree?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: How can I look at a recursive table dependency tree?