执行会报错，cannot be cast automatically to type integer
调整执行语句：ALTER TABLE table_name ALTER COLUMN column_name TYPE integer USING(column_name::integer);
运行正常。PostgreSQL 修改列报错：cannot be cast automatically to type integer
推荐阅读
执行会报错，cannot be cast automatically to type integer
调整执行语句：ALTER TABLE table_name ALTER COLUMN column_name TYPE integer USING(column_name::integer);
运行正常。