PostgreSQL compatibility issue

When loading /sitemap I see the following in the drupal logs :

"query: SELECT DISTINCT u.uid, u.name FROM users u, node n INNER JOIN n ON u.uid = n.uid WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC LIMIT 10 OFFSET 0 in /www/default/drupal-5.2/includes/database.pgsql.inc on line 144."

To which PostgreSQL says :

'ERROR: relation "n" does not exist'

I guess this is a PostgreSQL-ism vs MySQL-ism