PostgreSQL: database upgrade failure (hashes not copied & table dropped)

upgrade.php log:

phpass module
Update #6200

ALTER TABLE {users} RENAME "pass" TO "pass_old"
ALTER TABLE {users} ADD COLUMN pass varchar(128) default ''
UPDATE {users} SET pass = CAST(pass_old AS varchar)
ALTER TABLE {users} ALTER pass SET NOT NULL
ALTER TABLE {users} DROP COLUMN pass_old
Failed: UPDATE {users} u SET u.pass = (SELECT up.hash FROM {user_phpass} up WHERE up.uid = u.uid) WHERE EXISTS (SELECT up.hash FROM {user_phpass} up WHERE up.uid = u.uid)
DROP TABLE {user_phpass}

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "u" of relation "users" does not exist LINE 1: UPDATE users u SET u.pass = (SELECT up.hash FROM user_phpass...

Failure due to table alias included in set clause parameter.
Correct update query should be as follows:

UPDATE users u SET pass = (SELECT up.hash FROM user_phpass up WHERE up.uid = u.uid) WHERE EXISTS (SELECT up.hash FROM user_phpass up WHERE up.uid = u.uid)