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

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: How can I look at a recursive table dependency tree?
Дата
Msg-id
49749108.6090004@archonet.com
Ответ на
Re: How can I look at a recursive table dependency tree? (Ivan Sergio Borgonovo)
Список
Дерево обсуждения
How can I look at a recursive table dependency tree? Igor Katson <descentspb@gmail.com>
Re: How can I look at a recursive table dependency tree? "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: How can I look at a recursive table dependency tree? Emi Lu <emilu@encs.concordia.ca>
Re: How can I look at a recursive table dependency tree? Greg Stark <stark@enterprisedb.com>
Re: How can I look at a recursive table dependency tree? Tom Lane <tgl@sss.pgh.pa.us>
Re: How can I look at a recursive table dependency tree? Richard Huxton <dev@archonet.com>
Re: How can I look at a recursive table dependency tree? Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: How can I look at a recursive table dependency tree? Richard Huxton <dev@archonet.com>
Re: How can I look at a recursive table dependency tree? Ivan Sergio Borgonovo <mail@webthatworks.it>
Re: How can I look at a recursive table dependency tree? Richard Huxton <dev@archonet.com>
Re: How can I look at a recursive table dependency tree? Igor Katson <descentspb@gmail.com>
Re: How can I look at a recursive table dependency tree? Filip Rembiałkowski <plk.zuber@gmail.com> 
Ivan Sergio Borgonovo wrote:
> On Mon, 19 Jan 2009 14:19:51 +0000
> Richard Huxton  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
В списке pgsql-general по дате отправления
Предыдущее
От: A. Kretschmer
Дата:
Следующее
От: Ivan Sergio Borgonovo
Дата:
FAQ