Skip to main content

postgresql

2014

Restore PostgreSQL backup within Heroku
·138 words·1 min
heroku postgresql
Recently I was playing around with my local database in my Rails project deployed using Heroku. Eventually, I screwed up and had to delete all the data. I use rake db: reset and rake db:create`, but how would I populate the data again?
Rails Postgresql Error ORDER clause
·135 words·1 min
rails postgresql
While working on a rails project recently, I stepped on an error that said: PG::Error: ERROR: column “number” must appear in the GROUP BY clause or be used in an aggregate function`,