Aaron Burnett <aburnett(at)bzzagent(dot)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