"Charles Mortell" <cmortell@xxxxxxxxxxxx> 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
