Postgres 8.3 - sales reports syntax error

On the sales reports page, you get an error message:

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "s.order_status_id" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/drupal-6.8/includes/database.pgsql.inc on line 139.

user warning: query: SELECT s.order_status_id, s.title, s.weight, COUNT(o.order_status) as order_count FROM uc_orders as o LEFT JOIN uc_order_statuses as s ON s.order_status_id = o.order_status GROUP BY order_status, s.title, s.weight ORDER BY s.weight DESC in /var/www/drupal-6.8/sites/all/modules/ubercart/uc_reports/uc_reports.admin.inc on line 350.

To fix, edit uc_reports.admin.inc, line 350 and change

$result = db_query("SELECT s.order_status_id, s.title, s.weight, COUNT(o.order_status) as order_count FROM {uc_orders} as o LEFT JOIN {uc_order_statuses} as s ON s.order_status_id = o.order_status GROUP BY order_status, s.title, s.weight ORDER BY s.weight DESC");

TO

$result = db_query("SELECT s.order_status_id, order_status, s.title, s.weight, COUNT(o.order_status) as order_count FROM {uc_orders} as o LEFT JOIN {uc_order_statuses} as s ON s.order_status_id = o.order_status GROUP BY s.order_status_id, order_status, s.title, s.weight ORDER BY s.weight DESC");

(adds order_status to the select clause, and order_status_id to the group clause)