Re: Known but bad behavior with alter user? - Mailing list pgsql-hackers

* Joshua D. Drake (jd@commandprompt.com) wrote:
> 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.

Wouldn't this be because the username is used as the salt for MD5 and so
there's no way to update the password because the system doesn't know
the original password?
Enjoy,
    Stephen