Ruby on Rails 4 - Using Rake on Heroku

Question

I was moving my app from Nitrous.io which uses SQLite to Heroku for production which uses Postgres, and I got the following error. 2 things, I don't get why it won't do change_column, and I definitely don't understand their "hint". How can I go about implementing properly?

-- change_column(:messages, :sender, :integer)                                                                                                    
PG::DatatypeMismatch: ERROR:  column "sender" cannot be cast automatically to type integer                                                        
HINT:  Specify a USING expression to perform the conversion.                                                                                      
: ALTER TABLE "messages" ALTER COLUMN "sender" TYPE integer

The attributes were strings, and I wanted to change to integers so I could reference them. Any help? Below is my db migration that it is referencing:

class ChangeSenderReceiverToInteger < ActiveRecord::Migration
  def change
    change_column(:messages, :sender, :integer)
    change_column(:messages, :receiver, :integer)
  end
end

Prakash Murthy · Accepted Answer · 2014-12-30 16:50:37Z

1

Try:

change_column(:messages, :sender, 'integer USING CAST(sender AS integer)')

Ref: http://makandracards.com/makandra/18691-postgresql-vs-rails-migration-how-to-change-columns-from-string-to-integer

answered Dec 30, 2014 at 16:50

Prakash Murthy

13.1k3 gold badges48 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Ruby on Rails 4 - Using Rake on Heroku

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related