Postgres Pro
Downloads
Home   >   mailing lists

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

From Ivan Sergio Borgonovo
Subject Re: How can I look at a recursive table dependency tree?
Date
Msg-id 20090119153015.49e98533@dawn.webthatworks.it
Whole thread Raw
In response to Re: How can I look at a recursive table dependency tree?  (Richard Huxton <dev@archonet.com>)
Responses Re: How can I look at a recursive table dependency tree?
List pgsql-general
Tree view 
On Mon, 19 Jan 2009 14:19:51 +0000
Richard Huxton <dev@archonet.com> 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;

Isn't it going to be a pretty expensive way to see?

Is the default log level enough to take note of the things that will
be touched? (including eg. sequences, indexes etc...)?

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How can I look at a recursive table dependency tree?
Next
From: Filip Rembiałkowski
Date:
Subject: Re: How can I look at a recursive table dependency tree?