Appended is a small documentation patch that adds a note to the CREATE ROLE
page, based on what Tom Lane told me here:
http://archives.postgresql.org/pgsql-general/2005-11/msg00998.php
I think this behavior should be explicitly noted in the docs.
Joachim