# HG changeset patch
# User Dan
# Date 1215878467 14400
# Node ID c9ea830a211f8da234ada288d7f8f140e2bb578f
# Parent  b3a33b6616819bd1d7d21752cb784fab20027964
Fixed a few more PostgreSQL bugs with insert_id() and an issue with setting SERIAL columns manually. May break things if installed into a database without first dropping tables.

diff -r b3a33b661681 -r c9ea830a211f includes/dbal.php
--- a/includes/dbal.php	Sat Jul 12 10:49:10 2008 -0400
+++ b/includes/dbal.php	Sat Jul 12 12:01:07 2008 -0400
@@ -1141,7 +1141,7 @@
         eval($cmd);
       }
     }
-    $last_was_insert = preg_match('/^INSERT INTO ([a-z0-9_]+)\(/i', $this->latest_query, $match);
+    $last_was_insert = preg_match('/^INSERT INTO ([a-z0-9_]+)/i', $this->latest_query, $match);
     if ( $last_was_insert )
     {
       // trick based on PunBB's PostgreSQL driver
diff -r b3a33b661681 -r c9ea830a211f install/schemas/postgresql_stage2.sql
--- a/install/schemas/postgresql_stage2.sql	Sat Jul 12 10:49:10 2008 -0400
+++ b/install/schemas/postgresql_stage2.sql	Sat Jul 12 12:01:07 2008 -0400
@@ -389,11 +389,11 @@
 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   (2);
   
-INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
-  (1, 'user_rank_member', ''),
-  (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
-  (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'),
-  (4, 'user_rank_guest', '');
+INSERT INTO {{TABLE_PREFIX}}ranks(rank_title, rank_style) VALUES
+  ('user_rank_member', ''),
+  ('user_rank_mod', 'font-weight: bold; color: #00AA00;'),
+  ('user_rank_admin', 'font-weight: bold; color: #AA0000;'),
+  ('user_rank_guest', '');
 
 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   (2,'Administrators',3,1),