How do I handle too long index names in a Ruby on Rails ActiveRecord migration?

by

Provide the :name option to add_index, e.g.:

add_index :studies,
  ["user_id", "university_id", "subject_name_id", "subject_type_id"], 
  unique: true,
  name: 'my_index'

If using the :index option on references in a create_table block, it takes the same options hash as add_index as its value:

t.references :long_name, index: { name: :my_index }

More Related Contents:

  1. Using Rails, how can I set my primary key to not be an integer-typed column?
  2. How can I rename a database column in a Ruby on Rails migration?
  3. Rails DB Migration – How To Drop a Table?
  4. rake db:schema:load vs. migrations
  5. Rails migration for change column
  6. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  7. Rails migration for has_and_belongs_to_many join table
  8. Using Rails Migration on different database than standard “production” or “development”
  9. Add a default value to a column through a migration
  10. How can I rollback a specific migration?
  11. Run a single migration file
  12. Rails 3 migrations: Adding reference column?
  13. Index on multiple columns in Ruby on Rails
  14. Adding foreign key to a rails model
  15. How do I add some inserts in rails migration?
  16. how to permit an array with strong parameters
  17. Begin, Rescue and Ensure in Ruby?
  18. How to “pretty” format JSON output in Ruby on Rails
  19. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  20. Devise form within a different controller
  21. Rails layouts per action?
  22. In Rails, how do you render JSON using a view?
  23. No secret option provided to Rack::Session::Cookie warning?
  24. Profile model for Devise users?
  25. Rails: Missing host to link to! Please provide :host parameter or set default_url_options[:host]
  26. Rails how do I – export data with send_data then redirect_to a new page?
  27. Double colons before class names in Ruby?
  28. Using attr_accessor and attr_accessible on the same field
  29. Storing Objects in a Session in Rails
  30. unable to install pg gem

Leave a Comment