* Joshua D. Drake ([EMAIL PROTECTED]) 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
signature.asc
Description: Digital signature