Wikitools not compatible with PostgreSQL?

Hm. This is a problem. I'm not sure what's wrong. PostgreSQL people, any help?

Side note: this should only affect you on the duplicate node page?

I fixed this bug locally by editing /var/www/html/sites/all/modules/wikitools/wikitools.admin.inc and changing the " to ' and the surrounding ' to " in lines 154, 155, 158 and 159.

Thus,

    if (wikitools_treat_underscore_as_space()) {
      $n1_title = 'REPLACE(". $n1_title .", "_", " ")';
      $n2_title = 'REPLACE(". $n2_title .", "_", " ")';
    }
    if (wikitools_treat_dash_as_space()) {
      $n1_title = 'REPLACE(". $n1_title .", "-", " ")';
      $n2_title = 'REPLACE(". $n2_title .", "-", " ")';
    }

Became

    if (wikitools_treat_underscore_as_space()) {
      $n1_title = "REPLACE('. $n1_title .', '_', ' ')";
      $n2_title = "REPLACE('. $n2_title .', '_', ' ')";
    }
    if (wikitools_treat_dash_as_space()) {
      $n1_title = "REPLACE('. $n1_title .', '-', ' ')";
      $n2_title = "REPLACE('. $n2_title .', '-', ' ')";
    }

I am not sure but this might break the MySQL side of things.

here's a patch, not sure if its the complete fix but it fixes what is outlined above.

I will review the path.

After I applied this patch, the error was gone but another one appeared.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /var/html/drupal-6.13/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT DISTINCT(n1.nid) FROM node n1, node n2 WHERE LOWER(REPLACE(n1.title, '_', ' ')) = LOWER(REPLACE(n2.title, '_', ' ')) AND n1.nid != n2.nid AND n1.type IN('wiki') AND n2.type IN('wiki') ORDER BY n1.title ASC LIMIT 10 OFFSET 0 in /var/html/drupal-6.13/sites/all/modules/contrib/wikitools/wikitools.admin.inc on line 129.

According to this thread: http://archives.postgresql.org/pgsql-sql/2007-02/msg00161.php
The SQL statement is incorrect.

Here is an updated patch which also fix the other error I mentioned in comment #5.

looks good, I'm happy :)

Thanks, committed and should be fixed on the development branch.