From 0b756cf2f413f0b68a0773860e3aff9ba6151e7e Mon Sep 17 00:00:00 2001 From: Jason Etheridge <jason@esilibrary.com> Date: Thu, 8 Sep 2011 01:56:49 -0400 Subject: [PATCH] fire last_update_time trigger on user insert in addition to update Signed-off-by: Jason Etheridge <jason@esilibrary.com> Signed-off-by: Thomas Berezansky <tsbere@mvlc.org> --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 7068bafd53..4208cd086b 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -126,7 +126,7 @@ END; $$ LANGUAGE plpgsql; CREATE TRIGGER au_update_trig - BEFORE UPDATE ON actor.usr + BEFORE INSERT OR UPDATE ON actor.usr FOR EACH ROW EXECUTE PROCEDURE actor.au_updated(); CREATE TRIGGER actor_crypt_pw_update_trigger diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql index f53b347488..739a6c79bb 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql @@ -22,7 +22,7 @@ END; $$ LANGUAGE plpgsql; CREATE TRIGGER au_update_trig - BEFORE UPDATE ON actor.usr + BEFORE INSERT OR UPDATE ON actor.usr FOR EACH ROW EXECUTE PROCEDURE actor.au_updated(); COMMIT; -- 2.11.0