Seems like a bug that needs fixing. > "Glen and Rosanne Eustace" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026