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

From: Igor Katson <descentspb(at)gmail(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How can I look at a recursive table dependency tree?
Date: 2009-01-20 11:28:41
Message-ID: 4975B569.8040900@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-01-20 11:47:36 Re: Get object creation sql script in psql client
Previous Message Grzegorz Jaśkiewicz 2009-01-20 11:25:17 Re: Get object creation sql script in psql client