Re: [GENERAL] User names

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] User names
Дата
Msg-id 200101241445.JAA20940@candle.pha.pa.us
обсуждение исходный текст
Список pgsql-hackers
Seems like a bug that needs fixing.

> "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,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: M Carling
Дата:
Сообщение: [JOB] pqsql hacker needed
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Minor buglet in update...from (I think)