3 SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version);
5 CREATE OR REPLACE FUNCTION actor.change_password (user_id INT, new_pw TEXT, pw_type TEXT DEFAULT 'main')
10 SELECT actor.create_salt(pw_type) INTO new_salt;
12 IF pw_type = 'main' THEN
13 -- Only 'main' passwords are required to have
14 -- the extra layer of MD5 hashing.
15 PERFORM actor.set_passwd(
16 user_id, pw_type, md5(new_salt || md5(new_pw)), new_salt
20 PERFORM actor.set_passwd(user_id, pw_type, new_pw, new_salt);
23 $$ LANGUAGE 'plpgsql';