Core / Contrib Issues That Require a Postgres Review

If you know of an issue that is being postponed while waiting for a Postgres review or that adds PostgreSQL compliance to a module and therefore needs testing on PostgreSQL - add it to the top list with a brief description and an estimate of the time to review. Once reviewed, move the issues to the bottom "reviewed" list, perhaps with your name attached.

The more patches you review, the less chance there is of this happening

Need Reviews

• http://drupal.org/node/285074 - Simpletest broken on postgres
• http://drupal.org/node/107051 - Same user listed multiple times in who's online block
• http://drupal.org/node/223820 - Book module tests for postgres error
• http://drupal.org/node/181689 - Modify db_distinct_field() so it doesn't fail with count() queries. 15 minutes. needs a review on the regex and perhaps an install to verify the fix. install OG, enable access control for OG, then go to path: /q=og. should be error-free with the patch. (mmilano)
• http://drupal.org/node/189810 - Recipe Modules fails to insert ingredients.
• http://drupal.org/node/212264 - SQL Query failed on PostgreSQL 7.4 (syntax errors on admin pages with a fresh install).
• http://drupal.org/node/128846 - Rewritten PostgreSQL queries fail / Nodes are sorted in the wrong order on pgsql when using a node access module.
• http://drupal.org/node/229038 - "Query failed" error in Chart API.
• http://drupal.org/node/222389 - Add PostgreSQL support to "Job queue" module.
• [Comment notify query for people to send mails to missing column aliases and uses = '' instead of is null in where] (http://drupal.org/node/308585)
• Add your issue here

Reviewed

• Critical Core Comment Index - To test: install drupal5 with comment module, upgrade to Drupal6.
• http://drupal.org/node/247526 - PostgreSQL support in FeedAPI update functions.
• Improve bulk update speed using a cast - Especially needs postgres testers - reviewed by aufumy.

Committed without thorough review

• http://drupal.org/node/242048 - Replace 'Blue Smurf' in search results message - and it apparently fails on postgresql: http://drupal.org/node/264836
• http://drupal.org/node/190128 - _block_rehash fails on pgsql.
• http://drupal.org/node/146466 - Search improvements.
• http://drupal.org/node/189837 - Remove temporary table from comment.install | Drupal6 Core | 5 minutes (setup new installation of Core, make sure it doesn't blow up.
• Pathauto new install fails on Postgresql - Code needs review. Just have a clean drupal5 installation on postgres, install Pathauto for the first time (after patching pathauto). Make sure the variable table's column width gets resized.
• http://drupal.org/node/232564 - Comment notify refactored data storage and postgresql compliance