Re: ALTER TABLE -- how to add ON DELETE CASCADE?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ALTER TABLE -- how to add ON DELETE CASCADE?
Дата
Msg-id 6042.1141770997@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ALTER TABLE -- how to add ON DELETE CASCADE?  (felix@crowfix.com)
Ответы Re: ALTER TABLE -- how to add ON DELETE CASCADE?  (felix@crowfix.com)
Список pgsql-general
felix@crowfix.com writes:
>     ALTER TABLE A COLUMN AA ADD CONSTRAINT DELETE ON CASCADE

You're missing the specification of the foreign key, not to mention
spelling the CASCADE clause backwards.  Try

ALTER TABLE A ADD FOREIGN KEY(AA) REFERENCES B(BB) ON DELETE CASCADE

> \h alter table seems to be missing any way to add a constraint to a
> column.

It's there, though you have to look to \h create table to see the
alternatives for "table_constraint".

            regards, tom lane

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

Предыдущее
От: felix@crowfix.com
Дата:
Сообщение: ALTER TABLE -- how to add ON DELETE CASCADE?
Следующее
От: felix@crowfix.com
Дата:
Сообщение: Re: ALTER TABLE -- how to add ON DELETE CASCADE?