Re: [HACKERS] Re: User names cannot contain `-'

On 27 Apr 1998, John Goerzen wrote:

> "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> writes:
>
> > I have a bug reported on the Debian package of 6.3.2:
> >
> > > videotapes=> grant all on tapes to www-data;
> > > ERROR: aclparse: non-existent user "www"
> >
> > It is, in fact, impossible to create the user www-data:
> >
> > template1=> create user www-data;
> > ERROR: parser: parse error at or near "-"
> > template1=> create user 'www-data';
> > ERROR: parser: parse error at or near "'"
>
> I believe createuser program did that for me (either that or it was
> preinstalled; I don't recall.) I did not issue a direct SQL command
> to do it, so I think it is likely that createuser did it.
>
> In any case:
>
>
> template1=> select usename, usesysid, valuntil from pg_shadow;
> usename |usesysid|valuntil
> --------+--------+----------------------------
> postgres| 31|Sat Jan 31 00:00:00 2037 CST
> www-data| 33|Sat Jan 31 00:00:00 2037 CST
> jgoerzen| 1000|Sat Jan 31 00:00:00 2037 CST
> (3 rows)

This might have already been gone over, but if this was an upgrade
from a previous release, its possible that this was created with a
'dump/reload'?