Index: openacs-4/contrib/packages/portal/sql/postgresql/portal-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/portal/sql/postgresql/portal-package-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/portal/sql/postgresql/portal-package-create.sql	25 Oct 2002 21:29:17 -0000	1.1
+++ openacs-4/contrib/packages/portal/sql/postgresql/portal-package-create.sql	25 Sep 2003 02:12:16 -0000	1.2
@@ -25,7 +25,7 @@
 
 select define_function_args('portal__new', 'portal_id,name,theme_id,template_id,object_type;portal,creation_date,creation_user,creation_ip,context_id');
 
-create or replace function portal__new (integer,varchar,integer,integer,varchar,timestamp,integer,varchar,integer)
+create or replace function portal__new (integer,varchar,integer,integer,varchar,timestamptz,integer,varchar,integer)
 returns integer as '
 declare
     p_portal_id                     alias for $1;
@@ -113,7 +113,7 @@
                            where page_id = v_page.page_id
             loop
 
-                select portal_seq.nextval
+                select nextval(''portal_seq'')
                 into v_new_element_id
                 from dual;
 
@@ -130,7 +130,7 @@
                              where element_id = v_element.element_id
                 loop
 
-                    select portal_seq.nextval
+                    select nextval(''portal_seq'')
                     into v_new_parameter_id
                     from dual;