Re: [GENERAL] User names

Seems like a bug that needs fixing.

> "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026