Hello,
Take the following:
template1=# alter user foo rename to bar;
NOTICE: MD5 password cleared because of role rename
NOTICE: MD5 password cleared because of role rename
ALTER ROLE
template1=#
Now we have to reset the password.. which seems an extra
step that shouldn't be required.
Joshua D. Drake