Re: User names cannot contain `-'

"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)

--
John Goerzen Linux, Unix programming jgoerzen(at)complete(dot)org |
Developer, Debian GNU/Linux (Free powerful OS upgrade) www.debian.org |
----------------------------------------------------------------------------+
``You'll notice that this scanner, Bill [Gates]...'' <Blue Screen of Death>
``Whoa!'' <Applause> ``Moving right along....'' -- Microsoft (Comdex
video at: http://cnn.com/TECH/computing/9804/20/gates.comdex/index.html