Error: operator does not exist: character varying = integer

ruby-on-rails-3 sqlite postgresql heroku

This typically happens when the foreign key in the database is not an integer.

For example:

LINE 1: SELECT "hotels".* FROM "hotels" WHERE ("hotels".user_id = 1)                                                                ^

In this case, PostgreSQL expects user_id to be an integer, but it almost looks like it's telling you that it was actually a varchar.

I would try removing the column and adding it again.

CodeHunter