I had problems in development environment using mysql (with the default values in migrations), now I use Prostgres with heroku projects. I'd recommend it in development to have the same environment like heroku.
jesús. On Wed, Jun 16, 2010 at 6:24 PM, Neil Middleton <[email protected]>wrote: > I've had this exact issue, which is why I now make sure my dev environment > is the same as Heroku in every single way reasonably possible. (Ruby > version, DB, etc). > > SQLite doesn't seem to care if foreign keys aren't ints, Postgres does, > which is why you really should develop on Postgres where possible. > > Neil > > > On Wed, Jun 16, 2010 at 3:28 PM, webdevotion <[email protected]>wrote: > >> Thanks guys for your time. >> The problem was that status was defined as text >> in the migration file. >> >> * ouch * >> >> >> >> >> On Jun 16, 3:46 pm, webdevotion <[email protected]> wrote: >> > Hey >> > >> > We have a problem with our Projects controller. >> > Where we want to select all the projects with status set to true we >> > use: >> > >> > p = Project.where(:status => true) >> > >> > It works locally, but it doesn't work on the Heroku instance. >> > >> > Does work, but not agnostic >> > p = Project.where(:status => '1') >> > >> > What's the best practice to solve this ( little ) problem? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<heroku%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/heroku?hl=en. >> >> > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > -- Jesús Navarrete Blog: http://blog.jenaiz.com Twitter: http://twitter.com/jenaiz -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
