Index: openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql,v diff -u -r1.21 -r1.22 --- openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql 18 Jun 2004 18:21:57 -0000 1.21 +++ openacs-4/packages/acs-kernel/sql/postgresql/site-nodes-create.sql 10 Mar 2010 00:44:03 -0000 1.22 @@ -69,7 +69,7 @@ return tree_sortkey from site_nodes where node_id = p_node_id; end;' language 'plpgsql' stable strict; -create or replace function site_node_insert_tr () returns opaque as ' +create or replace function site_node_insert_tr () returns trigger as ' declare v_parent_sk varbit default null; v_max_value integer; @@ -98,7 +98,7 @@ on site_nodes for each row execute procedure site_node_insert_tr (); -create or replace function site_node_update_tr () returns opaque as ' +create or replace function site_node_update_tr () returns trigger as ' declare v_parent_sk varbit default null; v_max_value integer;