Fix password trigger

[ndwebbie.git] / database / functions / user_password.sql

diff --git a/database/functions/user_password.sql b/database/functions/user_password.sql
index 889e49ebb233790592400e7978bd7ef92bda6e01..c15cc00226acf607ac4eb5e15d248560014d4265 100644 (file)
--- a/database/functions/user_password.sql
+++ b/database/functions/user_password.sql
@@ -1,8 +1,13 @@
 CREATE OR REPLACE FUNCTION user_password() RETURNS trigger
     AS $_X$
 DECLARE
+       old_password TEXT;
 BEGIN
-       IF COALESCE(NEW.password <> OLD.password,TRUE) AND
+       IF TG_OP = 'UPDATE'
+       THEN
+               old_password := OLD.password;
+       END IF;
+       IF COALESCE(NEW.password <> old_password,TRUE) AND
                NOT NEW.password SIMILAR TO '$2a$\d+$[a-zA-Z0-9./]+'
        THEN
                NEW.password := crypt(NEW.password,gen_salt('bf',10));