列“xxxx"的默认值无法在 Postgres DB 中自动转换为类型 boolean [英] default for column "xxxx" cannot be cast automatically to type boolean in Postgres DB
本文介绍了列“xxxx"的默认值无法在 Postgres DB 中自动转换为类型 boolean的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试将 brs.parts 表中的一列从字符更改为布尔值.到目前为止,该列的数据为 Y/N.我正在使用以下命令
I am trying to update a column in brs.parts table from character varying to boolean. The column has data as Y/N till now. I am using the below command
ALTER TABLE brs.parts ALTER COLUMN is_dpm_scanned TYPE BOOLEAN USING is_dpm_scanned::BOOLEAN
<小时>
但我收到以下错误:
But I am getting the following error:
********* 错误 *********
********* Error **********
ERROR: default for column "is_dpm_scanned" cannot be cast automatically to type boolean
SQL state: 42804
<小时>
表定义为:
The table definition was:
CREATE TABLE brs.parts (
id serial NOT NULL PRIMARY KEY,
webcrt_part_id INTEGER,
event_id INTEGER,
webcrt_job_id INTEGER,
incoming_serial_number CHARACTER VARYING(256),
outgoing_serial_number CHARACTER VARYING(256),
part_number CHARACTER VARYING(256),
tag_number NUMERIC,
is_dpm_scanned CHARACTER VARYING(1) DEFAULT 'N'::CHARACTER VARYING,
current_operation_id INTEGER,
creation_date DATE,
created_by CHARACTER VARYING(20) NOT NULL,
last_updated_date DATE,
last_updated_by CHARACTER VARYING(20) NOT NULL,
is_delete CHARACTER VARYING(1) DEFAULT 'N'::CHARACTER VARYING
);
推荐答案
在更改类型之前,您必须删除默认约束:
You have to drop default constraint before changing the type:
ALTER TABLE parts
ALTER COLUMN is_dpm_scanned DROP DEFAULT,
ALTER COLUMN is_dpm_scanned TYPE BOOLEAN USING is_dpm_scanned::BOOLEAN,
ALTER COLUMN is_dpm_scanned SET DEFAULT FALSE;
另见:在 postgresql 中将列从字符串更改为字符串数组.
这篇关于列“xxxx"的默认值无法在 Postgres DB 中自动转换为类型 boolean的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文