Обсуждение: problem with ALTER GROUP

Please help! Unfortunetely I gave numbers for user names (column "usename" in
pg_shadow). Now in 7.0 we have ALTER GROUP, but the statement

test=# ALTER GROUP anygroup ADD USER 1234;

where 1234 can be any number, will result this error message:

ERROR:  parser: parse error at or near "1234"

I couldn't find any workarounds yet. No conversions solved my problem.
Any ideas?

Regards,
Zoltan

Kovacs Zoltan Sandor writes:

> test=# ALTER GROUP anygroup ADD USER 1234;

> ERROR:  parser: parse error at or near "1234"

Hmm, who would have thought of that? Try ... USER "1234" (double quotes).
We might be able to do better there though.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> writes:
> test=# ALTER GROUP anygroup ADD USER 1234;
> where 1234 can be any number, will result this error message:
> ERROR:  parser: parse error at or near "1234"

Double quotes around the username, perhaps?
        regards, tom lane

> > test=# ALTER GROUP anygroup ADD USER 1234;
> 
> > ERROR:  parser: parse error at or near "1234"
> 
> Hmm, who would have thought of that? Try ... USER "1234" (double quotes).
Unfortunetely it also doesn't work. I tried conversions as well, without
any success.

Zoltan

> > > test=# ALTER GROUP anygroup ADD USER 1234;
> > > ERROR:  parser: parse error at or near "1234"
> > Try ... USER "1234" (double quotes).
> Unfortunetely it also doesn't work.

lockhart=# create user "1234";
CREATE USER
lockhart=# create group test;
CREATE GROUP
lockhart=# ALTER GROUP test ADD USER 1234;
ERROR:  parser: parse error at or near "1234"
lockhart=# ALTER GROUP test ADD USER "1234";
ALTER GROUP

What does "not work" mean? Is the result unusable?
                    - Thomas

> lockhart=# ALTER GROUP test ADD USER "1234";
> ALTER GROUP
Hmmm, it works for me, too... I don't know, what I did before... Thanks!

Zoltan