Thread

1. problem with ALTER GROUP

   Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> — 2000-06-22T20:55:21Z

   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
   
   
   

2. Re: problem with ALTER GROUP

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-06-22T22:41:28Z

   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
   
   

3. Re: problem with ALTER GROUP

   Peter Eisentraut <peter_e@gmx.net> — 2000-06-22T22:42:03Z

   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
   
   
   

4. Re: problem with ALTER GROUP

   Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> — 2000-06-23T10:54:13Z

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

5. Re: problem with ALTER GROUP

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2000-06-23T14:10:01Z

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

6. Re: problem with ALTER GROUP

   Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> — 2000-06-24T10:25:01Z

   > 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