Thanks Tom, It was not supressed for notice, so I changed it to 'debug1' and it gave me the answers I was looking for. On 2/22/09 6:07 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Aaron Burnett <aburnett@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
