How determine a Views dependents

Поиск
Список
Период
Сортировка
От Charles Mortell
Тема How determine a Views dependents
Дата
Msg-id OBEBKAHJIDHDLCIIMKHKOEFGCAAA.cmortell@apt-cafm.com
обсуждение исходный текст
Ответы Re: How determine a Views dependents  (Erik Jones <erik@myemma.com>)
Re: How determine a Views dependents  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Fellow Postgressors,
    I took over an existing PG 8.0 database running on Windows XP. I need to
update a view so I know I need to drop the existing view and all the objects
that depend on it.
    The DB is large enough that I can't just look through it with PGAdmin. In
an organized way, how can I find out what those dependents are?
    If I need to use pg_depend, I could use some help in how to do that.
    Thanks!

Charles Mortell
Advanced Planning Technologies, Inc.
On the Mississippi River at La Crosse, WI
cmortell at apt-cafm dot com


В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Optimizer problem in 8.1.6
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Optimizer problem in 8.1.6