Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.63.2.7 -r1.63.2.8
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	1 Jul 2016 09:34:08 -0000	1.63.2.7
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	4 Jan 2017 15:54:48 -0000	1.63.2.8
@@ -488,8 +488,8 @@
 create index cr_revisions_lob_idx ON cr_revisions(lob);
 create index cr_revisions_item_id_idx ON cr_revisions(item_id);
 
-create trigger cr_revisions_lob_trig before delete or update or insert
-on cr_revisions for each row execute procedure on_lob_ref();
+CREATE TRIGGER cr_revisions_lob_trig AFTER UPDATE or DELETE or INSERT
+ON cr_revisions FOR EACH ROW EXECUTE PROCEDURE on_lob_ref();
 
 create index cr_revisions_by_mime_type on cr_revisions(mime_type);
 create index cr_revisions_title_idx on cr_revisions(title);
