Heroku Postgres conflict with join

Asked Aug 23 '11 at 18:41

Active Aug 23 '11 at 18:41

Viewed 123 times

I do the development with MySQL, and there is no errors, but in Heroku with PostgreSQL i'm having a bad time.

This is the code where it complains:

joins( [ :invoice, { :invoice => :project } ] ).group("projects.name").order("value DESC").sum("receipts.value")

It gives me this message : "ActiveRecord::StatementInvalid (PGError: ERROR: column "receipts.value" must appear in the GROUP BY clause or be used in an aggregate function"

Do you know how can I resolve this issue?

Thank you in advance.

asked Aug 23 '11 at 18:41

Davidslv

Check out http://stackoverflow.com/questions/1769361/postgresql-group-by-different-from-mysql – Gazler Aug 23 '11 at 18:48
Add receipts.value to the GROUP BY, just like the error message tells you to do. – Frank Heikens Aug 23 '11 at 18:52
2

Step 1: Stop developing on MySQL (or SQLite) if you're publishing to Heroku. Step 2: .... Step 3: Profit. – mu is too short Aug 23 '11 at 19:17
Heroku wasn't the main idea. I fixed this one, but putting all the columns in the group doesn't do what I want – Davidslv Aug 26 '11 at 12:57

Heroku Postgres conflict with join

0 Answers0