sodabrew/puppet-dashboard — pull request #283 by sodabrew (2014-03-21 06:03:35+00:00)
Title: Revert "Include name in the group by to allow the field to be sorted"

This reverts commit c7448ab4cfd38c790e5fd0652e225d217e754edd.

Per #276 and #282, in PostgreSQL 8.4 you cannot SELECT columns not mentioned in a GROUP BY unless they are used in an aggregate function. In PostgreSQL 9.0 and above, you may have ungrouped columns in the SELECT clause if the GROUP BY is a unique column.

The query in question requires this behavior, or the query has to be greatly restructured. The interest for supporting this is to use the stock Pg 8.4 in RHEL 6.