| From: | Jim Mercer <jim(at)pneumonoultramicroscopicsilicovolcanoconiosis(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Glen and Rosanne Eustace <agree(at)godzone(dot)net(dot)nz>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: User names |
| Date: | 2000-12-14 06:06:53 |
| Message-ID: | 20001214010653.J11043@pneumonoultramicroscopicsilicovolcanoconiosis.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)pneumonoultramicroscopicsilicovolcanoconiosis(dot)ca ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka jim(at)reptiles(dot)org +1 416 410-5633 ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Esa Pikkarainen | 2000-12-14 08:06:44 | space problem |
| Previous Message | Tom Lane | 2000-12-14 05:41:34 | Re: User names |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2000-12-14 07:38:01 | vacuum crash on 6.5.3 |
| Previous Message | Tom Lane | 2000-12-14 05:44:43 | Re: (Updated) Table File Format |