> 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
nk to true.
From efb33eac3599773402446d2812ec544313c65e29 Mon Sep 17 00:00:00 2001
From: jian he
Date: Wed, 20 Aug 2025 10:59:18 +0800
Subject: [PATCH v1 1/1] UPDATE with invalid domain constraint
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
should UP
hi.
should UPDATE statement need to verify that the domain value is satisfied with
invalid domain constraints?
Álvaro Herrera already mentioned this in [1], but I just want to confirm it.
drop table if exists dt1;
drop domain if exists d1;
create domain d1 as int;
create table dt1(i int, c d1);
i
