Re: question on viewing dependencies

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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
>