Aaron Burnett <aburn...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
