Re: User names cannot contain `-' - Mailing list pgsql-hackers

From John Goerzen
Subject Re: User names cannot contain `-'
Date
Msg-id 87g1iyn3t4.fsf@garfield.complete.org
Whole thread Raw
In response to User names cannot contain `-'  ("Oliver Elphick" <olly@lfix.co.uk>)
Responses Re: [HACKERS] Re: User names cannot contain `-'
List pgsql-hackers
"Oliver Elphick" <olly@lfix.co.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@complete.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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] postgres init script things solved
Next
From: dg@illustra.com (David Gould)
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL