Re: [HACKERS] ALTER ROLES - questions

2005-09-23 Thread Bruce Momjian
OK, I have added comments to gram.y to document what is happening. ALTER ROLE ... ROLE is supported for ALTER GROUP. The others like IN ROL are supported by CREATE, but when used by ALTER throw an error printing their internal names, so it is kind of cryptic. Not sure what we should do to improv

Re: [HACKERS] ALTER ROLES - questions

2005-09-23 Thread Tom Lane
Bruce Momjian writes: > I see a lot of ALTER ROLE items not documented: > SYSID > IN ROLE > ROLE/USER > ADMIN > Is anyone working on documenting these? No, because they're not actually supported. The grammar happens to accept them because we use the same productions for

Re: [HACKERS] ALTER ROLES - questions

2005-09-23 Thread Bruce Momjian
I see a lot of ALTER ROLE items not documented: SYSID IN ROLE ROLE/USER ADMIN Is anyone working on documenting these? I see these flags as used by and documented in CREATE ROLE too. Should they be disabled for ALTER ROLE? ---

Re: [HACKERS] ALTER ROLES - questions

2005-08-22 Thread Jim C. Nasby
On Mon, Aug 15, 2005 at 09:49:35AM -0400, Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > > I played around with roles a bit today and noticed some minor things: > > > ALTER ROLE seems to support ALTER ROLE ROLE - but that > > form is not mentioned in the docs: > > There ar

Re: [HACKERS] ALTER ROLES - questions

2005-08-15 Thread Stephen Frost
* Stefan Kaltenbrunner ([EMAIL PROTECTED]) wrote: > ALTER ROLE seems to support ALTER ROLE ROLE - but that > form is not mentioned in the docs: It's not really encouraged and is more because (iirc) that's what 'alter group' did. > ALTER ROLE IN ROLE (undocumented but seems logical to try > be

Re: [HACKERS] ALTER ROLES - questions

2005-08-15 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > I played around with roles a bit today and noticed some minor things: > ALTER ROLE seems to support ALTER ROLE ROLE - but that > form is not mentioned in the docs: There are some cases that work, but are not documented (or supported), as a resu

[HACKERS] ALTER ROLES - questions

2005-08-15 Thread Stefan Kaltenbrunner
Hi! I played around with roles a bit today and noticed some minor things: ALTER ROLE seems to support ALTER ROLE ROLE - but that form is not mentioned in the docs: playground=# CREATE ROLE myrole; CREATE ROLE playground=# CREATE ROLE myrole2; CREATE ROLE playground=# ALTER ROLE myrole ROLE myr