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

Ivan Sergio Borgonovo wrote:
> On Mon, 19 Jan 2009 14:19:51 +0000
> Richard Huxton <dev@archonet.com> wrote:
>
>> Igor Katson wrote:
>>> 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?

Not necessarily - you're not likely to have a lot of concurrency on a
backup database. And we are all testing this sort of stuff on a backup
database, aren't we?

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

I don't think so. You could pull the information from pg_depend
(http://www.postgresql.org/docs/8.3/static/catalog-pg-depend.html) which
is what the DROP will be doing.

--
  Richard Huxton
  Archonet Ltd