Only run password trigger when password is changed

diff --git a/database/functions/user_password.sql b/database/functions/user_password.sql
index c15cc00226acf607ac4eb5e15d248560014d4265..0e86be8d03bcd988d4b2d12836c1768be782a48d 100644 (file)
--- 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();
 */