Re: User names - Mailing list pgsql-general

From Jim Mercer
Subject Re: User names
Date
Msg-id 20001214010653.J11043@pneumonoultramicroscopicsilicovolcanoconiosis.ca
Whole thread Raw
In response to Re: User names  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, Dec 14, 2000 at 12:41:34AM -0500, Tom Lane wrote:
> 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.

also be aware that as of FreeBSD 4.1 or so, the crypt() function on freebsd
is actually doing some kinda MD5 thingy unless you specifically use
crypt_set_format().

--
[ Jim Mercer          jim@pneumonoultramicroscopicsilicovolcanoconiosis.ca ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[ aka                        jim@reptiles.org              +1 416 410-5633 ]

pgsql-general by date:

Previous
From: "rob"
Date:
Subject: Re: Re: Daily Digest V1 #108
Next
From: Anand Raman
Date:
Subject: Re: Postgres failover implementation