Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql,v diff -u -N -r1.51 -r1.52 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 18 Jun 2004 18:21:57 -0000 1.51 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-objects-create.sql 26 Jul 2004 12:21:40 -0000 1.52 @@ -257,10 +257,12 @@ create function acs_objects_last_mod_update_tr () returns opaque as ' begin - new.last_modified := now(); - + if new.last_modified is null then + new.last_modified := old.last_modified; + elsif new.last_modified = old.last_modified then + new.last_modified := now(); + end if; return new; - end;' language 'plpgsql'; create trigger acs_objects_last_mod_update_tr before update on acs_objects