I'm trying to execute a simply change_column on oracle, with the following output: -- change_column(:comments, :text, :string, {:limit=>1000}) rake aborted! An error has occurred, this and all later migrations canceled:
Index name 'temp_index_altered_comments_on_commentable_id_and_commentable_type' on table 'altered_comments' is too long; the limit is 64 characters
How do I specify the name of the temporary index in the migration?
e.g.
add_index :things , :thing_id , :name => 'thing_index'
Yes, but how do I do this with change_column?
No idea, and I doubt you can 
Can you post the migration itself and the current schema for the table?
You know what? Nevermind. Turns out that table is deleted later in my migrations, so I'll just comment this line out. Still would like to know how to do this, if it's even possible.
It looks like the issue is an index established earlier on commentable_id and commentable_type - Oracle appears to be *copying* the whole deal to a temporary table (altered_comments) along with the indexes. I suspect the only solution would be to shorten the name of the index on the original table before doing the change_column...
--Matt Jones
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks