problem with ALTER GROUP

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

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

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