error changing DB table column from integer to BigInt

Question

I am trying to change my table column from an integer to a bigint I create a migration and then added this code to the migration file.

class ChangeMileageToBigint < ActiveRecord::Migration
  def change
  execute <<-SQL
    ALTER TABLE posts
    ALTER COLUMN mileage TYPE bigint USING mileage::bigint
  SQL
end
end

However, I am getting this error when running rake db:migrate

C:\Sites\jeepjig>rake db:migrate
DL is deprecated, please use Fiddle
== 20150315145856 ChangeMileageToBigint: migrating ============================
-- execute("    ALTER TABLE posts\n    ALTER COLUMN mileage TYPE bigint USING mileage::bigint\n")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: near "ALTER": syntax error:     ALTER TABLE posts
    ALTER COLUMN mileage TYPE bigint USING mileage::bigint
C:/Sites/jeepjig/db/migrate/20150315145856_change_mileage_to_bigint.rb:3:in `change'
C:in `migrate'
ActiveRecord::StatementInvalid: SQLite3::SQLException: near "ALTER": syntax error:     ALTER TABLE posts
    ALTER COLUMN mileage TYPE bigint USING mileage::bigint
C:/Sites/jeepjig/db/migrate/20150315145856_change_mileage_to_bigint.rb:3:in `change'
C:in `migrate'
SQLite3::SQLException: near "ALTER": syntax error
C:/Sites/jeepjig/db/migrate/20150315145856_change_mileage_to_bigint.rb:3:in `change'
C:in `migrate'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Petrus Prinsloo · Accepted Answer · 2015-03-15 21:38:10Z

1

According to the documentation sqlite it is not supported you will need to copy the data to new column of bigint type and change its name

answered Mar 15, 2015 at 21:38

Petrus Prinsloo

2945 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Petrus Prinsloo Over a year ago

it seems that it's better to create a new table and rename it after copying over the data

Collectives™ on Stack Overflow

error changing DB table column from integer to BigInt

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related