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

Поиск
Список
Период
Сортировка
От Igor Katson
Тема Re: How can I look at a recursive table dependency tree?
Дата
Msg-id 4975B569.8040900@gmail.com
обсуждение исходный текст
Ответ на Re: How can I look at a recursive table dependency tree?  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Richard Huxton wrote:
> Igor Katson wrote:
>
>> 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?
>>
>
> BEGIN;
> DROP CASCADE...
> -- check things
> ROLLBACK;
>
>
Thanks everyone, who responded. DROP TABLE while in transaction (if you
just want to look at the cascading drops) is really fast and safe.

В списке pgsql-general по дате отправления:

Предыдущее
От: Igor Katson
Дата:
Сообщение: Re: Get object creation sql script in psql client
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Get object creation sql script in psql client