Using Drupal 7.8 on Ubuntu 11.04 with Apache 2.2.17, PHP 5.3.5-1ubuntu7.2 and PostgreSQL(libpq).

Installed module ok.
Enabled module ok.
Then attempted to configure it via the modules/list screen.
Get the following pop-up:

PDOException: SQLSTATE[42883]: Undefined function: 7 ERROR: function count(bigint, bigint) does not exist LINE 1: ...d) node_count, count(distinct tn.nid) term_count, count(dist... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.: SELECT td.vid, n.type, count(distinct tn.nid) node_count, count(distinct tn.nid) term_count, count(distinct tn.nid, tn.tid) missing_ctag_count FROM {taxonomy_index} tn INNER JOIN {taxonomy_term_data} td ON td.tid = tn.tid INNER JOIN {node} n ON n.nid = tn.nid LEFT JOIN {community_tags} ct ON ct.nid = tn.nid AND ct.tid = tn.tid WHERE ct.nid IS NULL GROUP BY td.vid, n.type; Array ( ) in _community_tags_get_all_out_of_sync_missing_tag_counts() (line 450 of /www/drupal-7.8/sites/all/modules/community_tags/community_tags.admin.inc).

It seems there's quite a few TODO's around the area of line 450 of community_tags.admin.inc stating that the SQL needs to be updated for Drupal v7 API. Afraid I'm too new to all this to know the difference between the 6 and 7 API's but suspect the DB can't cope with two arguments to the COUNT aggregate.

Will.