I am building up a rails application that I cloned from my friend. I am using Ubuntu 13.10, rails 3.2.14. I am using a postgresql database and when I try to run rake db:migrate it gives me some error like this:
PG::UndefinedObject: ERROR: type "json" does not exist LINE 1: ALTER TABLE "filters" ADD COLUMN "search_string" json
I installed pg version :- 9.3.1
running rails db output is :-psql (9.3.1, server 9.1.10)
running select version(); :-PostgreSQL 9.1.10 on i686-pc-linux-gnu
Why is it showing psql -version different from the version connected to my database??
My friend is working on 9.2.4 I don't know why this error is occurring, I tried several times to downgrade using purge or remove commands to remove 9.3.1 all goes well but when I check psql --version it again shows me 9.3.1 . Any solution ???