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

From: Richard Huxton <dev(at)archonet(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:19:51
Message-ID: 49748C07.3070701@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-01-19 14:30:15 Re: How can I look at a recursive table dependency tree?
Previous Message A. Kretschmer 2009-01-19 13:51:43 Re: How can I display the contents of a function?