Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v diff -u -r1.29 -r1.30 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 26 Jun 2009 00:38:33 -0000 1.29 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 10 Mar 2010 00:44:03 -0000 1.30 @@ -61,7 +61,7 @@ return tree_sortkey from acs_object_types where object_type = p_object_type; end;' language 'plpgsql'; -create function acs_object_type_insert_tr () returns opaque as ' +create function acs_object_type_insert_tr () returns trigger as ' declare v_parent_sk varbit default null; v_max_value integer; @@ -84,7 +84,7 @@ on acs_object_types for each row execute procedure acs_object_type_insert_tr (); -create function acs_object_type_update_tr () returns opaque as ' +create function acs_object_type_update_tr () returns trigger as ' declare v_parent_sk varbit default null; v_max_value integer;