Incompatability with PostgreSQL 8.3

PostgreSQL 8.3 removed a lot of implicit casts. After enabling the footermap module, Drupal always returns a blank page. The Apache error log is empty (PHP logging is not enabled, but it would probably show this).

If the footermap module directory is removed, the following errors are displayed:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: text = integer at character 114 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/html/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT ml.*, coalesce(n.status,1) as nstatus FROM menu_links ml LEFT OUTER JOIN node n ON substr(ml.link_path,6) = n.nid WHERE ml.plid = 0 AND ml.module <> 'system' AND ml.hidden <> -1 ORDER BY ml.plid,ml.weight in /var/www/html/drupal/sites/default/modules/footermap/footermap.module on line 180.

To fix, change the query:

SELECT ml.*, coalesce(n.status,1) as nstatus FROM menu_links ml LEFT OUTER JOIN node n ON substr(ml.link_path,6)::integer = n.nid WHERE ml.plid = 0 AND ml.module <> 'system' AND ml.hidden <> -1 ORDER BY ml.plid,ml.weight

The explicit ::integer resolves the issue. Whether it is cross-platform for MySQL etc is unknown.