对话中每一次回答后面都有：异常null value in column "is_deleted" of relation "application_chat" violates not-null constraint DETAIL: Failing row contains

MaxKB
1

我跟maxkb对话中，回答后面有下面这个，之前没有的，我也没有修改过数据库的啥配置，莫名出现的，有大佬遇到这种问题吗
异常null value in column “is_deleted” of relation “application_chat” violates not-null constraint
DETAIL: Failing row contains

我需要进入容器修改数据库表的这个字段 is_deleted 列为空可以为空吗

2

我把is_deleted 该字段默认值删除之后，重新设置字段的默认值，现在已经正常了

ALTER TABLE application_chat ALTER COLUMN is_deleted DROP DEFAULT;
ALTER TABLE application_chat ALTER COLUMN is_deleted SET NOT NULL;
ALTER TABLE application_chat ALTER COLUMN is_deleted SET DEFAULT false;

3

image
image1901×725 113 KB

上面是对话的完整截图，信息如下：
异常null value in column “is_deleted” of relation “application_chat” violates not-null constraint
DETAIL: Failing row contains (2024-11-13 17:12:24.155683+08, 2024-11-13 17:12:24.1557+08, 5e851f02-a19f-11ef-8493-0242ac110003, 什么是typecho, ed923c8a-062b-11ef-bd5e-0242ac110003, ceaeac38-a106-11ef-848b-0242ac110003, null).