Index: openacs-4/packages/acs-kernel/sql/postgresql/lob.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/lob.sql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/acs-kernel/sql/postgresql/lob.sql 24 Jul 2004 14:44:55 -0000 1.5 +++ openacs-4/packages/acs-kernel/sql/postgresql/lob.sql 10 Mar 2010 00:44:03 -0000 1.6 @@ -24,7 +24,7 @@ refcount integer not null default 0 ); -create or replace function on_lobs_delete() returns opaque as ' +create or replace function on_lobs_delete() returns trigger as ' begin delete from lob_data where lob_id = old.lob_id; return old; @@ -51,7 +51,7 @@ -- and PG 7.0. The ACS doesn't share LOBs between tables -- or rows within a table anyway, I don't think/hope. -create or replace function on_lob_ref() returns opaque as ' +create or replace function on_lob_ref() returns trigger as ' begin if TG_OP = ''UPDATE'' then if new.lob = old.lob then