--- mollom.install (saved version)
+++ (current document)
@@ -5,13 +5,28 @@
  * Implementation of hook_install().
  */
 function mollom_install() {
-  db_query("CREATE TABLE {mollom} (
-    did varchar(255) NOT NULL default '',
-    session varchar(255) NOT NULL default '',
-    quality varchar(255) NOT NULL default '',
-    PRIMARY KEY (did),
-    INDEX (session)
-  );");
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      db_query("CREATE TABLE {mollom} (
+        did varchar(255) NOT NULL default '',
+        session varchar(255) NOT NULL default '',
+        quality varchar(255) NOT NULL default '',
+        PRIMARY KEY (did),
+        INDEX (session)
+      );");
+      break;
+      
+    case 'pgsql':
+      db_query("CREATE TABLE {mollom} (
+        did varchar(255) NOT NULL default '',
+        session varchar(255) NOT NULL default '',
+        quality varchar(255) NOT NULL default '',
+        PRIMARY KEY (did)
+      );");
+      db_query("CREATE INDEX {mollom}_session_idx ON {mollom} (session);");
+      break;
+  }
 }
 
 /**