Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql,v
diff -u -r1.33 -r1.34
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	13 Feb 2009 13:36:02 -0000	1.33
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-permissions-create.sql	10 Mar 2010 00:44:03 -0000	1.34
@@ -118,7 +118,7 @@
 -- This would be better, since the same query could be used for both oracle
 -- and postgresql.
 
-create or replace function acs_priv_hier_ins_del_tr () returns opaque as '
+create or replace function acs_priv_hier_ins_del_tr () returns trigger as '
 declare
         new_value       integer;
         new_key         varbit default null;
@@ -190,7 +190,7 @@
 on acs_privilege_hierarchy for each row
 execute procedure acs_priv_hier_ins_del_tr ();
 
-create or replace function acs_priv_del_tr () returns opaque as '
+create or replace function acs_priv_del_tr () returns trigger as '
 begin
 
   delete from acs_privilege_descendant_map
@@ -418,7 +418,7 @@
        lck  integer
 );
 
-create function acs_permissions_lock_tr () returns opaque as '
+create function acs_permissions_lock_tr () returns trigger as '
 begin
         raise EXCEPTION ''FOR LOCKING ONLY, NO DML STATEMENTS ALLOWED'';
         return null;