Rails migration returning index too long

Question

Below is the migration file I have defined to rename the column in schooling_document_types_managing_areas table but the issue is when I run the migration I am getting an error Index name is too long; the limit is 63 characters. Then I tried, something like

rename_column :schooling_document_types_managing_areas, :service_id, :managing_area_id, name: :index_schooling_documents_on_managing_area

then it returns

ArgumentError: wrong number of arguments (given 4, expected 3).

Any idea where I am going wrong

class RenameColumnName < ActiveRecord::Migration[5.1]
  def up
    rename_column :schooling_document_types_managing_areas, :service_id, :managing_area_id
  end

  def down
    rename_column :schooling_document_types_managing_areas, :managing_area_id, :service_id
  end
end

Alter Lagos · Accepted Answer · 2021-06-22 22:48:47Z

2

What about removing the index and re-adding it?

def change
  remove_index :schooling_document_types_managing_areas, name: :index_schooling_document_types_managing_areas_on_service_id
  rename_column :schooling_document_types_managing_areas, :service_id, :managing_area_id
  add_index :schooling_document_types_managing_areas, name: :index_schooling_documents_on_managing_area
end

Also, I'm not sure about the nature of your data in production for that service_id field, but keep in mind that just renaming isn't the safest way in case there are people using your app in the very exact moment that you're running your migration.

answered Jun 22, 2021 at 22:48

Alter Lagos

12.7k2 gold badges74 silver badges98 bronze badges

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

Collectives™ on Stack Overflow

Rails migration returning index too long

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related