Changing a column name with migration failed

rubyonrails-talk
1

Hi All,

I had a column-name "changed" that I wanted to replaced with "accessed".

I tried: class ModifyChangedAttribute < ActiveRecord::Migration   def self.up     rename_column(:csvs, :created, :accessed)   end

  def self.down     rename_column(:csvs, :accessed, :created)   end end

The migration failed: 1. It was apparent because rake db/migrate returned only one line indicating the app's "home" 2. Sqlite3's .dump table_name showed that "created" was unchanged.

I see now that I provided no table_name to the migration. How do I do that?

I'm running: ruby 1.8.6 Rails 2.2.1 Win-Pro/SP3

Thanks in Advance, Richard

2

BTW, I put up all the code on http://www.pastie.org/343735

HTH, Richard

3

My earlier statement, "I don't have a column name" is incorrect.

The statement: rename_column(:csvs, :created, :accessed) provided the table_name "cvs" as symbol, the old_name "created" as a symbol, and the new_name.

So I don't have a clue as to what's wrong. All the code is on http://www.pastie.org/343735, as I mentioned before.

Again, thanks for any insights you may offer, Richard