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