ALTER CONSTRAINT change action

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема ALTER CONSTRAINT change action
Дата
Msg-id CAMkU=1wBEU=RJxtEMZ_UcXWoQrXUydACoF=-m40D8Sh9uESxeA@mail.gmail.com
обсуждение исходный текст
Ответы Re: ALTER CONSTRAINT change action  (Euler Taveira <euler@timbira.com.br>)
Список pgsql-hackers
Дерево обсуждения
Currently you can't change the ON DELETE action or ON UPDATE action of an existing constraint.   You have to drop the constraint and create it again with the action you want.  This is not a light-weight activity, as it has to validate the new constraint.

Is there a fundamental reason that ALTER TABLE...ALTER CONSTRAINT cannot change the action?  Or is just that no one got around to it?

Cheers,

Jeff

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Avoid extra Sort nodes between WindowAggs when sorting can be reused
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Few comments on commit 857f9c36 (skip full index scans )