Site search indexing broken on PostgreSQL

Problem/Motivation

Site content indexing for search is currently broken when using PostgreSQL as database backend. The problem is within the Node-Search-Plugin which throws the following error in PostgreSQL logs on each cron run:

ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 153
STATEMENT: SELECT DISTINCT n.nid FROM node n LEFT JOIN search_dataset d ON d.type = 'node_search' AND d.sid = n.nid WHERE d.sid IS NULL OR d.reindex <> 0 ORDER BY d.reindex ASC, n.nid ASC LIMIT 100 OFFSET 0

Proposed resolution
The fix is as simple as adding "d.reindex" to the SELECT statement.

Remaining tasks
User test on MySQL and SQLite.

User interface changes
None.

API changes
None.