> On Aug 20, 2025, at 11:31, jian he wrote:
>
> On Tue, Aug 19, 2025 at 10:08 PM jian he wrote:
>>
>>
>> alter domain d1 add constraint cc check(value <> 2) not valid;
>>
>
>> update dt1 set i = i + 1;
>> update dt1 set c = c;
>> update dt1 set i = i + 1, c = c;
>> update dt1 set i = i + 1
On Tue, Aug 19, 2025 at 10:08 PM jian he wrote:
>
> drop table if exists dt1;
> drop domain if exists d1;
> create domain d1 as int;
> create table dt1(i int, c d1);
> insert into dt1 values(1,2);
> alter domain d1 add constraint cc check(value <> 2) not valid;
>
> update dt1 set i = i + 1;
> up
