Index: openacs-4/packages/cms/sql/postgresql/cms-permissions.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/postgresql/cms-permissions.sql,v diff -u -N -r1.12 -r1.13 --- openacs-4/packages/cms/sql/postgresql/cms-permissions.sql 5 Apr 2018 14:44:08 -0000 1.12 +++ openacs-4/packages/cms/sql/postgresql/cms-permissions.sql 25 Oct 2020 18:57:08 -0000 1.13 @@ -364,7 +364,7 @@ ); insert into v_items (value) values ('{0}'); -create or replace function v_items_tr () returns opaque as ' +create or replace function v_items_tr () returns trigger as ' begin raise EXCEPTION ''Only updates are allowed on this table''; return null; @@ -379,7 +379,7 @@ ); insert into v_perms (value) values ('{''}'); -create or replace function v_perms_tr () returns opaque as ' +create or replace function v_perms_tr () returns trigger as ' begin raise EXCEPTION ''Only updates are allowed on this table''; return null; @@ -685,7 +685,7 @@ -- A trigger to automatically grant item creators the cm_write and cm_perm -- permissions -create or replace function cr_items_permission_tr () returns opaque as ' +create or replace function cr_items_permission_tr () returns trigger as ' declare v_user_id parties.party_id%TYPE; begin