diff -r eb4a10b9b7aa -r 8f0cbce6d5f3 install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql
--- a/install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql	Sun Dec 06 21:54:55 2009 -0500
+++ b/install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql	Sun Dec 06 21:56:46 2009 -0500
@@ -33,6 +33,9 @@
 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4;
 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   (4, 'user_rank_guest', '');
+  
+-- For some reason this is required, it came up in my QA testing on a2hosting
+SELECT NEXTVAL('{{TABLE_PREFIX}}ranks_rank_id_seq'::regclass);
 
 -- Other rank-related columns
 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int DEFAULT NULL;