Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cannot drop table ordre because other objects depend on it

Cannot drop table ordre because other objects depend on it

From
Bjørn T Johansen
Date:
I am trying to drop a table and I get the following error msg:

Cannot drop table ordre because other objects depend on it
Use DROP ... CASCADE to drop the dependent objects too

How do I check which object  the table depends on? As far as I know, the table doesn't have any dependencies, at least it shoulnd't... :)

Regards,

BTJ

-- 
-----------------------------------------------------------------------------------------------
Bjørn T Johansen (BSc,MNIF)
Executive Manager
btj@havleik.no                  Havleik Consulting
Phone : +47 67 54 15 17         Conradisvei 4
Fax : +47 67 54 13 91           N-1338 Sandvika
Cellular : +47 926 93 298       http://www.havleik.no
-----------------------------------------------------------------------------------------------
"The stickers on the side of the box said "Supported Platforms: Windows
98, Windows NT 4.0,
Windows 2000 or better", so clearly Linux was a supported platform."
-----------------------------------------------------------------------------------------------
Attachment

Re: Cannot drop table ordre because other objects depend on it

From
Tom Lane
Date:
=?ISO-8859-1?Q?Bj=F8rn?= T Johansen <btj@havleik.no> writes:
> I am trying to drop a table and I get the following error msg:
> Cannot drop table ordre because other objects depend on it
> Use DROP ... CASCADE to drop the dependent objects too
> How do I check which object  the table depends on?

Use psql, or some other client code that doesn't drop notices on the
floor.  That error should come with a bunch of notices telling you
exactly what else would be dropped by DROP CASCADE.

            regards, tom lane