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


Thu, 22 Jun 2000 22:55:21 +0200 (CEST)
Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
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

Thu, 22 Jun 2000 18:41:28 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: problem with ALTER GROUP 
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


Fri, 23 Jun 2000 00:42:03 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: problem with ALTER GROUP
> > 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


Fri, 23 Jun 2000 12:54:13 +0200 (CEST)
Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
Re: problem with ALTER GROUP
> > > 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

Fri, 23 Jun 2000 14:10:01 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: problem with ALTER GROUP
> 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


Sat, 24 Jun 2000 12:25:01 +0200 (CEST)
Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
Re: problem with ALTER GROUP