Thread: How determine a Views dependents

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

On Jun 22, 2007, at 10:50 AM, Charles Mortell wrote:

> 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!

Have you looked at the output of \d <view name> in psql?

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

"Charles Mortell" <cmortell@apt-cafm.com> writes:
>     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?

The traditional way is

    drop view victim restrict;
    ... read the error message ...

            regards, tom lane