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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org