From: Michael Andreen <harv@ruin.nu>
Date: Tue, 17 Jan 2017 22:24:08 +0000 (+0100)
Subject: Only run password trigger when password is changed
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=e71f5648d2823f89024c52b77f9ab04d23a75a2d

Only run password trigger when password is changed
---

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();
 */