Recent Posts SQL Error appearing at top of page

The case I encountered where of the form COUNT(DISTINCT ON (node.nid) node.nid) which should be COUNT(DISTINCT node.nid). In the forum topic divamys suggest a fix for db_distinct_field, which works for me. I attached the patch.
note: I run postgres 7.4.11. I do not know if this works for all query rewrites or for all versions of postgres.

I had a similar but different error related to pgsql so I tried this patch, but it didn't help (I didn't expected it too, but thought perhaps it might).

Here is the issue I finally posted: http://drupal.org/node/141362

pwolanin and wizztick - can you describe a simple test case so that I could provide a review of the patch?

I tried this path:

1. Create some content
2. Visit the /tracker page

Expected results:
Errors

Actual Results:
Worked fine

I'm on pgsql8.1.8 if that matters.

I am having a similar issue:

http://drupal.org/node/153672

It looks like this might help me. I will examine the patch and test it.

I tested it and hand to comment out

# $query = preg_replace('/(ORDER BY )(?!'.$table.'\.'.$field.')/', '\1'."$table.$field, ", $query);

as well. I don't want it ordering off of the DISTINCT field name. Maybe there is cases were it should be added. But I think it was added because with DISTINCT ON you have to have the field name in the ORDER BY or it won't work. I am going to examine the CVS commits to see if there is anything else to this.

http://drupal.org/node/181689