Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.54 -r1.55
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	7 Jun 2008 20:28:47 -0000	1.54
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	10 Feb 2009 18:31:54 -0000	1.55
@@ -1284,7 +1284,7 @@
   v_revision_id integer;
 begin
 
-  select acs_object_id_seq.nextval into v_item_id;
+  select nextval(''t_acs_object_id_seq'') into v_item_id;
 
   PERFORM content_template__new(
                 ''default_template'',
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql,v
diff -u -r1.19 -r1.20
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql	4 Jun 2006 00:45:23 -0000	1.19
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql	10 Feb 2009 18:31:54 -0000	1.20
@@ -38,7 +38,7 @@
   end if;
 
   if new__name is null then
-    select acs_object_id_seq.nextval into v_extlink_id from dual;
+    select nextval(''t_acs_object_id_seq'') into v_extlink_id from dual;
     v_name := ''link'' || v_extlink_id;
   else
     v_name := new__name;
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v
diff -u -r1.45 -r1.46
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	4 Jun 2006 00:45:23 -0000	1.45
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	10 Feb 2009 18:31:54 -0000	1.46
@@ -367,7 +367,7 @@
   -- use the copy_id or generate a new copy_id if none is specified
   --   the copy_id is a revision_id
   if copy__copy_id is null then
-    select acs_object_id_seq.nextval into v_copy_id from dual;
+    select nextval(''t_acs_object_id_seq'') into v_copy_id from dual;
   else
     v_copy_id := copy__copy_id;
   end if;
Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql	25 Sep 2006 17:59:16 -0000	1.6
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-logs-create.sql	10 Feb 2009 18:31:54 -0000	1.7
@@ -61,7 +61,7 @@
     insert into acs_logs
      (log_id, log_level, log_key, message)
     values
-     (acs_log_id_seq.nextval, ''notice'', notice__log_key, notice__message);
+     (nextval(''t_acs_log_id_seq''), ''notice'', notice__log_key, notice__message);
 
     return 0; 
 end;' language 'plpgsql';
@@ -77,7 +77,7 @@
     insert into acs_logs
      (log_id, log_level, log_key, message)
     values
-     (acs_log_id_seq.nextval, ''warn'', warn__log_key, warn__message);
+     (nextval(''t_acs_log_id_seq''), ''warn'', warn__log_key, warn__message);
 
     return 0; 
 end;' language 'plpgsql';
@@ -93,7 +93,7 @@
     insert into acs_logs
      (log_id, log_level, log_key, message)
     values
-     (acs_log_id_seq.nextval, ''error'', error__log_key, error__message);
+     (nextval(''t_acs_log_id_seq''), ''error'', error__log_key, error__message);
 
     return 0; 
 end;' language 'plpgsql';
@@ -109,7 +109,7 @@
     insert into acs_logs
      (log_id, log_level, log_key, message)
     values
-     (acs_log_id_seq.nextval, ''debug'', debug__log_key, debug__message);
+     (nextval(''t_acs_log_id_seq''), ''debug'', debug__log_key, debug__message);
 
     return 0; 
 end;' language 'plpgsql';
Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql,v
diff -u -r1.25 -r1.26
--- openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	8 Sep 2008 20:05:17 -0000	1.25
+++ openacs-4/packages/acs-kernel/sql/postgresql/groups-create.sql	10 Feb 2009 18:31:54 -0000	1.26
@@ -450,9 +450,9 @@
 insert into group_type_rels 
 (group_rel_type_id, rel_type, group_type)
 values
-(acs_object_id_seq.nextval, 'membership_rel', 'group');
+(nextval('t_acs_object_id_seq'), 'membership_rel', 'group');
 
 insert into group_type_rels 
 (group_rel_type_id, rel_type, group_type)
 values
-(acs_object_id_seq.nextval, 'composition_rel', 'group');
+(nextval('t_acs_object_id_seq'), 'composition_rel', 'group');
Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	12 Mar 2004 19:19:46 -0000	1.18
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	10 Feb 2009 18:31:54 -0000	1.19
@@ -105,7 +105,7 @@
     begin
         -- generate a message id now so we can get an rfc822 message-id
         if p_message_id is null then
-            select acs_object_id_seq.nextval into v_message_id;
+            select nextval(''t_acs_object_id_seq'') into v_message_id;
         else
             v_message_id := p_message_id;
         end if;
Index: openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql	30 Jan 2009 02:36:56 -0000	1.11
+++ openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql	10 Feb 2009 18:31:54 -0000	1.12
@@ -117,17 +117,17 @@
 insert into group_type_rels
 (group_rel_type_id, group_type, rel_type)
 values
-(acs_object_id_seq.nextval, 'application_group', 'composition_rel');
+(nextval('t_acs_object_id_seq'), 'application_group', 'composition_rel');
 
 insert into group_type_rels
 (group_rel_type_id, group_type, rel_type)
 values
-(acs_object_id_seq.nextval, 'application_group', 'membership_rel');
+(nextval('t_acs_object_id_seq'), 'application_group', 'membership_rel');
 
 insert into group_type_rels
 (group_rel_type_id, group_type, rel_type)
 values
-(acs_object_id_seq.nextval, 'application_group', 'admin_rel');
+(nextval('t_acs_object_id_seq'), 'application_group', 'admin_rel');
 
 -----------
 -- Views --
Index: openacs-4/packages/acs-subsite/sql/postgresql/subsite-callbacks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/subsite-callbacks-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-subsite/sql/postgresql/subsite-callbacks-create.sql	17 Apr 2001 04:10:06 -0000	1.2
+++ openacs-4/packages/acs-subsite/sql/postgresql/subsite-callbacks-create.sql	10 Feb 2009 18:31:54 -0000	1.3
@@ -177,7 +177,7 @@
 begin
 
     if new__callback_id is null then
-       select acs_object_id_seq.nextval into v_callback_id;
+       select nextval(''t_acs_object_id_seq'') into v_callback_id;
     else
        v_callback_id := new__callback_id;
     end if;
Index: openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-create.sql	10 Jun 2005 09:47:23 -0000	1.5
+++ openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-create.sql	10 Feb 2009 18:31:54 -0000	1.6
@@ -194,7 +194,7 @@
 insert into group_type_rels
 (group_rel_type_id, group_type, rel_type)
 values
-(acs_object_id_seq.nextval, 'application_group', 'user_profile');
+(nextval('t_acs_object_id_seq', 'application_group', 'user_profile');
 
 
 -- This view is extremely fast, but for some reason its not so blaxing fast