From e71f5648d2823f89024c52b77f9ab04d23a75a2d Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 17 Jan 2017 23:24:08 +0100 Subject: [PATCH] Only run password trigger when password is changed --- database/functions/user_password.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/database/functions/user_password.sql b/database/functions/user_password.sql index c15cc00..0e86be8 100644 --- a/database/functions/user_password.sql +++ b/database/functions/user_password.sql @@ -18,5 +18,6 @@ $_X$ LANGUAGE plpgsql; /* alter table users alter COLUMN password drop not null ; -CREATE TRIGGER user_password BEFORE UPDATE OR INSERT ON users FOR EACH ROW EXECUTE PROCEDURE user_password() +DROP TRIGGER user_password ON users; +CREATE TRIGGER user_password BEFORE INSERT OR UPDATE OF password ON users FOR EACH ROW EXECUTE PROCEDURE user_password(); */ -- 2.39.2