Clarify 'dependent objects' for DROP COLUMN

Поиск
Список
Период
Сортировка
От Robins
Тема Clarify 'dependent objects' for DROP COLUMN
Дата
Msg-id CAEP4nAxFw=2pB-oJyWZkwo7hccggoDzooEBmv+umd1R-neyZXg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Clarify 'dependent objects' for DROP COLUMN  (Bruce Momjian <bruce@momjian.us>)
Список 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

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: The relation between "checkpoint_timeout" and "checkpoint_warning" is missing
Следующее
От: robins
Дата:
Сообщение: Clarify 'dependent objects' for DROP COLUMN