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

From Igor Katson
Subject Re: How can I look at a recursive table dependency tree?
Date
Msg-id 4975B569.8040900@gmail.com
Whole thread Raw
In response to Re: How can I look at a recursive table dependency tree?  (Richard Huxton <dev@archonet.com>)
List 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 by date:

Previous
From: Igor Katson
Date:
Subject: Re: Get object creation sql script in psql client
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Get object creation sql script in psql client