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.

Need Reviews

• http://drupal.org/node/225450 - New database layer
• 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