Re: question on viewing dependencies - Mailing list pgsql-general

Aaron Burnett <aburnett@bzzagent.com> writes:
> Hopefully a quick answer. Went to drop a table:

> drop table table_foo;
> ERROR:  cannot drop table table_foo because other objects depend on it
> HINT:  Use DROP ... CASCADE to drop the dependent objects too.

> Wanted to see what the dependencies were:

> BEGIN;
> drop table table_foo CASCADE;
> DROP TABLE
> ROLLBACK;

> Am I overlooking a step to actually seeing the dependant objects?

Maybe you have client_min_messages set to suppress NOTICEs?

            regards, tom lane