Index: openacs-4/packages/chat/sql/postgresql/chat-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/postgresql/chat-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/chat/sql/postgresql/chat-create.sql	19 Nov 2007 01:14:15 -0000	1.7
+++ openacs-4/packages/chat/sql/postgresql/chat-create.sql	14 Dec 2010 15:04:43 -0000	1.8
@@ -552,7 +552,7 @@
    v_msg chat_msgs.msg%TYPE;
 begin
     -- Get msg id from the global acs_object sequence.
-    select acs_object_id_seq.nextval into v_msg_id from dual;
+    select nextval(''t_acs_object_id_seq'') into v_msg_id from dual;
 
 
     select archive_p into v_msg_archive_p from chat_rooms where room_id = p_room_id;
