Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: How can I look at a recursive table dependency tree?
Date
Msg-id 49748C07.3070701@archonet.com
Whole thread Raw
In response to How can I look at a recursive table dependency tree?  (Igor Katson <descentspb@gmail.com>)
Responses Re: How can I look at a recursive table dependency tree?
Re: How can I look at a recursive table dependency tree?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How can I display the contents of a function?
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: How can I look at a recursive table dependency tree?