From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: User names |
Date: | 2000-12-14 05:41:34 |
Message-ID: | 19219.976772494@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
"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
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 2000-12-14 06:06:53 | Re: User names |
Previous Message | Sandeep Joshi | 2000-12-14 05:04:02 | trigger |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-14 05:44:43 | Re: (Updated) Table File Format |
Previous Message | Tatsuo Ishii | 2000-12-14 05:02:26 | Re: pg_options.sample |