Cannot drop table ordre because other objects depend on it
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."
-----------------------------------------------------------------------------------------------
Attachments:
=?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