Postgres error while adding multiple choice question

[Sjors]

When I try to add a multiple choice question to a survey I get the following error message:

ActiveRecord::StatementInvalid (PG::GroupingError: ERROR:  column "answers.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "answers".* FROM "answers"  WHERE "answers"."question...
               ^
: SELECT "answers".* FROM "answers"  WHERE "answers"."question_id" = $1 GROUP BY text  ORDER BY display_order, display_order DESC

Using Ruby 2.1.2, Rails 4.0.8, pg 0.17.1 and Postgres 9.3.1 on OSX Mavericks.

I don't get this error when I use SQLite.

[kjayma]

I'll take a look - thanks for the info.

[kjayma]

Able to reproduce problem. Will get you a fix.

[kjayma]

Should fix this error. Gem will generally work with postgres, but you may run into some other problems. It broke a couple of my tests, which I am working to get green again.