Heroku database import converts time column to text column. Can something be done about it?

Question

When i am doing

heroku db:push

to import the development database of my Rails application, the "time" columns become "text" columns. That is, they are "time" in my SQLite development database, and they were "time" on Heroku before my "push", but after that they became "text".

Is there a way to push my SQLite columns as "time"? Why is this happening?

Answer 1

Heroku released an app to make it very easy to use Postgresql on your Mac, I would recommend using that in development.

http://postgresapp.com/

If you deploy to a different database than you are using locally, you are bound to get issues.