Re: [GENERAL] question on viewing dependencies

2009-02-22 Thread Aaron Burnett
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" wrote: > Aaron Burnett writes: >> Hopefully a quick answer. Went to drop a table: > >> drop table table_foo; >> ERROR: cannot drop table tab

Re: [GENERAL] question on viewing dependencies

2009-02-22 Thread Tom Lane
Aaron Burnett 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 t

[GENERAL] question on viewing dependencies

2009-02-22 Thread Aaron Burnett
Hi, postgresql version 8.25 running on RHEL4 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: BE