Index: modules/project_issue/project_issue.install
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/project_issue/project_issue.install,v
retrieving revision 1.13
diff -u -p -u -p -r1.13 project_issue.install
--- modules/project_issue/project_issue.install	14 Aug 2007 07:08:00 -0000	1.13
+++ modules/project_issue/project_issue.install	15 Aug 2007 17:14:50 -0000
@@ -98,6 +98,7 @@ function project_issue_install() {
             file_size int default 0 NOT NULL,
             PRIMARY KEY (nid)
           );");
+        db_query("CREATE INDEX {project_issues}_pid_idx ON {project_issues}(pid)");
         db_query("CREATE INDEX {project_issues}_sid_idx ON {project_issues}(sid)");
       }
       if (!db_table_exists('project_comments')) {
@@ -116,6 +117,7 @@ function project_issue_install() {
             PRIMARY KEY (cid)
           );");
          db_query("CREATE SEQUENCE {project}_cid_seq INCREMENT 1 START 1");
+         db_query("CREATE INDEX {project_comments}_nid_idx ON {project_comments}(nid)");
       }
       if (!db_table_exists('project_subscriptions')) {
         db_query("CREATE TABLE {project_subscriptions} (
@@ -123,6 +125,7 @@ function project_issue_install() {
             uid int NOT NULL default '0',
             level smallint NOT NULL default '0'
           );");
+        db_query("CREATE INDEX {project_subscriptions}_nid_uid_level_idx ON {project_subscriptions}(nid, uid, level)");
       }
       if (!db_table_exists('project_issue_state')) {
         db_query("CREATE TABLE {project_issue_state} (
@@ -319,3 +322,18 @@ function project_issue_update_5001() {
   }
   return $ret;
 }
+
+/**
+ * Add missing pgsql indexes.
+ */
+function project_issue_update_5002() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'pgsql':
+      $ret[] = update_sql('CREATE INDEX {project_issues}_pid_idx ON {project_issues}(pid)');
+      $ret[] = update_sql('CREATE INDEX {project_comments}_nid_idx ON {project_comments}(nid)');
+      $ret[] = update_sql('CREATE INDEX {project_subscriptions}_nid_uid_level_idx ON {project_subscriptions}(nid, uid, level)');
+      break;
+  }
+  return $ret;
+}