PG Error trying to push rails db to heroku

Question

I'm trying to push my rails db to heroku using: heroku run rake db:migrate and getting the following error:

=  ChangeDateFormatInMyTable: migrating ======================================
-- change_column(:users, :date_of_birth, :datetime)
rake aborted!
An error has occurred, this and all later migrations canceled:

PG::Error: ERROR:  column "date_of_birth" cannot be cast to type "pg_catalog.timestamp"
: ALTER TABLE "users" ALTER COLUMN "date_of_birth" TYPE timestamp

What is the current type of :date_of_birth? You may need to explicitly convert the current values in that column to the new type. — user122376
– user122376, Commented May 12, 2012 at 23:56
:datetime... even when i do a db reset before trying to push to heroku i get this error...@kwbeam — js111
– js111, Commented May 13, 2012 at 0:07
Yeah, why are you issuing a change_column if it’s already a datetime? Showing the migration code for everything involving :date_of_birth would help. — Buck Doyle
– Buck Doyle, Commented May 13, 2012 at 0:11
Well i did several migrations changing the datatype in attempts to fix this problem (also changed the name from date_of_birth to dob).. the last being "change_column :users, :dob, :datetime" — js111
– js111, Commented May 13, 2012 at 0:12

Dain · Accepted Answer · 2012-05-13 03:35:33Z

2

Try a heroku run rake db:reset

Often times with Heroku and my PG Database, I have to do resets when I have massively changed things.

answered May 13, 2012 at 3:35

Dain

477 bronze badges

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

Comments

Aitul · Accepted Answer · 2012-11-10 15:19:57Z

1

Yes "Heroku run rake db:reset" definitely works. I have been having a similar problem

RemoveGirthFromProfile: migrating =========================================
-- remove_column(:profiles, :girth)
rake aborted!
An error has occurred, this and all later migrations canceled:

PG::Error: ERROR:  column "girth" of relation "profiles" does not exist
: ALTER TABLE "profiles" DROP "girth"

but when i reseted the database it solve the application errors i was even having on heroku

edited Nov 10, 2012 at 15:19

Aitul

2,9922 gold badges28 silver badges53 bronze badges

answered Nov 10, 2012 at 14:46

Mazterkizh

118 bronze badges

Collectives™ on Stack Overflow

PG Error trying to push rails db to heroku

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related