make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock

Поиск
Список
Период
Сортировка
От jian he
Тема make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock
Дата
Msg-id CACJufxHz92A88NLRTA2msgE2dpXpE-EoZ2QO61od76-6bfqurA@mail.gmail.com
обсуждение исходный текст
Ответы Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock
Список pgsql-hackers
hi.

We can still perform DML operations on a table while validating its
check constraint.
Similarly, it should be fine to do DML while validating domain constraints?
but currently, it's not allowed for domain constraints.

The attached patch addresses this problem.
so, with the patch, the following is allowed:

create domain d1 as int;
create table t(a d1);
alter domain d1 add constraint cc10 check(value > 10) not valid;

begin;
alter domain d1 validate constraint cc10;

--another session
INSERT INTO T SELECT 8;

Вложения

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