ruby-on-rails - PG::DatatypeMismatch: 错误: 列 "status"不能自动转换为整数类型

Question

我在开发中使用 sqlite3，但在迁移 PostgreSQL 时出现错误

sqlite 数据库迁移未发现此类错误。

错误日志

PG::DatatypeMismatch: ERROR:  column "status" cannot be cast automatically to type integer

HINT:  You might need to specify "USING status::integer".
/home/abc/abc/db/migrate/20200211044313_change_status_type_in_stages.rb:3:in `change'

20200113224031_create_stages.rb

class CreateStages < ActiveRecord::Migration[5.2]
  def change
    create_table :stages do |t|
      t.string :stage
      t.boolean :status

      t.timestamps
    end
  end
end

db/20200211044313_change_status_type_in_stages.rb

  def change
    change_column :stages, :status, :integer
  end

Answer 1

您需要指定应如何转换数据。

  change_column :stages, :status, 'integer USING CAST(status AS integer)'

或

  change_column :stages, :status, :integer, using: 'status::integer'

Changing the Column Type - Errors