make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated

Поиск
Список
Период
Сортировка
От jian he
Тема make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated
Дата
Msg-id CACJufxG=-Dv9fPJHqkA9c-wGZ2dDOWOXSp-X-0K_G7r-DgaASw@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Дерево обсуждения 
hi.

Looking at AlterDomainValidateConstraint, it seems currently, ALTER
DOMAIN VALIDATE
CONSTRAINT will re-validate a VALID constraint, which
would just waste cycles.
Ideally, this operation should be a no-op.

The attached patch addresses this by making ALTER DOMAIN VALIDATE CONSTRAINT a
no-op in such cases.

ALTER TABLE VALIDATE CONSTRAINT is already a no-op when the constraint is VALID.
Вложения

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