database issues

Seems that I'm having database issues. I get errors all over the place when I upload images. During the upload, viewing albums, and viewing images. They all seem to be centered around the pg_query() function. I'm a very basic developer (front end mostly) so please forgive my ignorance. Any help would be appreciated!

I'm running drupal 5.3 with the acidfree-5.x-1.x-dev version of acidfree. I've gone to the acidfree/test page on my domain and it reports that all is well there.

I'm using postgresql 8.2.5 and I've prepended this instance of drupal's tables with 'lemming_' so that I can differentiate between the various apps using my instance of the database (yes it is shared amongst other users on this box).

I'll post a few of the errors that I do get for your reference. Also, I'll delete the bug report referring to this issue and leave it in support for now.

And, an example can be found at www.uniquelemming.com

- If I view an album, I don't get an error.

- When I view an image I get the following error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: function concat(text) does not exist LINE 1: ...tid = 3 AND (n.moderate = 0 AND n.status = 1) AND CONCAT(LPA... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT(n.nid) FROM lemming_node n INNER JOIN lemming_term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 3 AND (n.moderate = 0 AND n.status = 1) AND CONCAT(LPAD(9999999999 - n.nid, 10, '0')) < '9999999989' in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 144.

- When I view the list of albums I get this error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT DISTINCT(n.nid), n.title, n.created FROM lemming_node n INNER JOIN lemming_term_node tn ON n.nid = tn.nid WHERE n.type <> 'acidfree' AND tn.tid = 3 AND n.status = 1 ORDER BY RAND() LIMIT 1 OFFSET 0 in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT DISTINCT(n.nid), n.title, n.created FROM lemming_node n INNER JOIN lemming_term_node tn ON n.nid = tn.nid WHERE tn.tid = 3 AND n.status = 1 ORDER BY RAND() LIMIT 1 OFFSET 0 in /home/zotsf/lemming_html/includes/database.pgsql.inc on line 144.