Thread:Extension talk:SubPageList/Broken DB query in Postgres 8.3

I ran into an issue when trying to test this extension. I thought I would include it on the discussion page for any others who may encounter the problem in the future. If this isn't the appropriate place, let me know, and I'll make the adjustment accordingly.

A query in SubPageList.class.php was making terrible noise and prevented the extension from working with Postgres 8.3 on a FreeBSD server.

I received the following output: Warning: pg_query [function.pg-query]: Query failed: ERROR: operator does not exist: ` text LINE 1: ...e_namespace = '0' AND page_is_redirect = '0'AND (`page_titl... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/wiki/includes/db/DatabasePostgres.php on line 584

Looking in SubPageList.class.php I found the offending line:

The following minor edit fixed the problem:

Hope documenting this somewhere helps someone out there.