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]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
