Rails Migration: Bigint on PostgreSQL seems to be failing?

ruby-on-rails postgresql activerecord migration bigint

For some reason the create table doesn't like bigint. You can, however do it with add_columm using the bigint data type:

add_column :table_name, :really_big_int, :bigint

Then you don't need that limit stuff.

ruby-on-rails postgresql activerecord migration bigint

This works in Rails 4

t.column :really_big_int, :bigint

ruby-on-rails postgresql activerecord migration bigint

Rails 5.0.0.1 it works:

  def change    create_table :huge do |t|        t.integer :big_bastard, limit: 8    end  end

CodeHunter