Re: User names

Can someone comment on this?

> "Glen and Rosanne Eustace" <agree@godzone.net.nz> writes:
> > Is there a defined max length for postgreSQL user names ?
> > If there is and it is 8, then createuser should enforce it.
> > If the length is > 8 then pg_passwd needs fixing so that it doesn't
> > truncate.
>
> A quick look in the pg_passwd sources indeed shows some hardwired limits
> on both username and password length.  This is bogus.  Anyone want to
> contribute a patch?
>
> For the record, the max username length should be NAMEDATALEN-1, and
> the password field in pg_shadow is 'text', so it should be happy to
> take any password that you're willing to type ;-).  However, crypt
> password processing depends on crypt(3), which more than likely ignores
> characters beyond the eighth on most platforms.
>
>             regards, tom lane
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026