Re: Cannot drop table ordre because other objects depend on it - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot drop table ordre because other objects depend on it
Date
Msg-id 17342.1062166472@sss.pgh.pa.us
Whole thread Raw
In response to Cannot drop table ordre because other objects depend on it  (Bjørn T Johansen <btj@havleik.no>)
List pgsql-general
=?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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL upgrade -> fails to start server
Next
From: Sander Smeenk
Date:
Subject: Re: PostgreSQL upgrade -> fails to start server