Index: openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql 22 Jul 2001 17:32:28 -0000 1.10 +++ openacs-4/packages/acs-kernel/sql/postgresql/groups-body-create.sql 3 Aug 2001 21:08:10 -0000 1.11 @@ -269,7 +269,7 @@ -- create or replace package body composition_rel -- function new -select define_function_args('composition_rel__new','rel_id,rel_type:composition_rel,object_id_one,object_id_two,creation_user,creation_ip'); +select define_function_args('composition_rel__new','rel_id,rel_type;composition_rel,object_id_one,object_id_two,creation_user,creation_ip'); create function composition_rel__new (integer,varchar,integer,integer,integer,varchar) returns integer as ' @@ -704,7 +704,7 @@ -- create or replace package body acs_group -- function new -select define_function_args('acs_group__new','group_id,object_type:group,creation_date:now(),creation_user,creation_ip,email,url,group_name,join_policy,context_id'); +select define_function_args('acs_group__new','group_id,object_type;group,creation_date;now(),creation_user,creation_ip,email,url,group_name,join_policy,context_id'); create function acs_group__new (integer,varchar,timestamp,integer,varchar,varchar,varchar,varchar,varchar,integer) returns integer as ' Index: openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql 22 Jul 2001 17:32:28 -0000 1.10 +++ openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql 3 Aug 2001 21:08:10 -0000 1.11 @@ -540,7 +540,7 @@ -- Add entries to acs_function_args for one function --- Usage: select define_function_args('function_name','arg1,arg2:default,arg3,arg4:default') +-- Usage: select define_function_args('function_name','arg1,arg2;default,arg3,arg4;default') create function define_function_args(varchar,varchar) returns integer as ' @@ -559,7 +559,7 @@ v_elem = split(p_arg_list, '','', v_arg_seq); while v_elem is not null loop - v_pos = instr(v_elem, '':'', 1, 1); + v_pos = instr(v_elem, '';'', 1, 1); if v_pos > 0 then v_arg_name := substr(v_elem, 1, v_pos-1); v_arg_default := substr(v_elem, v_pos+1, length(v_elem) - v_pos); 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.3 -r1.4 --- openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql 22 Jul 2001 17:31:29 -0000 1.3 +++ openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql 3 Aug 2001 21:08:10 -0000 1.4 @@ -126,7 +126,7 @@ -- return v_group_id; -- end new; -select define_function_args('application_group__new','group_id,object_type:application_group,creation_date:now(),creation_user,creation_ip,email,url,group_name,package_id,context_id'); +select define_function_args('application_group__new','group_id,object_type;application_group,creation_date;now(),creation_user,creation_ip,email,url,group_name,package_id,context_id'); create function application_group__new(integer,varchar,timestamp,integer,varchar,varchar,varchar,varchar,integer,integer) returns integer as '