Clarify 'dependent objects' for DROP COLUMN

Поиск
Список
Период
Сортировка
От robins
Тема Clarify 'dependent objects' for DROP COLUMN
Дата
Msg-id CAEP4nAxJzygfcywQDg3R=K=ZioF51xXF4v2e6A9NrWP-Un=P=Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-docs
Hi,

ALTER TABLE in postgresql.org/docs/devel/ says:

RESTRICT: Refuse to drop the column or constraint if there are any dependent objects. This is the default behavior.

Could someone confirm whether 'dependent objects' also includes SEQUENCES? i.e. if I create a sequence OWNED BY tbl.col1 and then try to drop the column with RESTRICT, should it allow this DROP? Currently it does, but by reading that line it seemed it shouldn't.

Thanks
--
Robins Tharakan
p.s.: Had to re-post this. Apologies if this lands up twice in the queue.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Robins
Дата:
Сообщение: Clarify 'dependent objects' for DROP COLUMN
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Clarify 'dependent objects' for DROP COLUMN