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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot drop table ordre because other objects depend on it
Дата
Msg-id 17342.1062166472@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cannot drop table ordre because other objects depend on it  (Bjørn T Johansen <btj@havleik.no>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL upgrade -> fails to start server
Следующее
От: Sander Smeenk
Дата:
Сообщение: Re: PostgreSQL upgrade -> fails to start server