Sql error using postgresql 8

I like very much that module, btw there are a couple of issues with drupal6/postgresql8:
- blog front page error:

Query failed: ERROR: column "u.name" must appear in the GROUP BY clause or be used in an aggregate function
query: SELECT u.name, COUNT(n.uid) AS nposts FROM users u INNER JOIN node n ON u.uid = n.uid WHERE n.status=1 AND n.type = 'blog' GROUP BY u.uid ORDER BY nposts DESC LIMIT 20 OFFSET 0 in /var/www/www.oth.org/drupal-6.2/sites/all/modules/blog_addons/blog_addons.module on line 143.

(solved grouping by u.name)

- front page of a user's blog:

Query failed: ERROR: function from_unixtime(integer) does not exist
query: SELECT n.nid, n.created, YEAR(FROM_UNIXTIME(n.created)) AS year, MONTH(FROM_UNIXTIME(n.created)) AS month, DAY(FROM_UNIXTIME(n.created)) AS day FROM node n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = 1 ORDER BY n.created DESC LIMIT 20 OFFSET 0 in /var/www/www.oth.org/drupal-6.2/sites/all/modules/blog_addons/blog_addons.module on line 422.

I think from_unixtime() is available only on mysql.

Thank you for that module.