Re: [HACKERS] [ADMIN] Unable to drop role

2010-08-26 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Code is here: else if (deptype == SHARED_DEPENDENCY_ACL) appendStringInfo(descs, _(access to %s), objdesc); in StoreObjectDescription(). Happy to change it to whatever is deemed

Re: [HACKERS] [ADMIN] Unable to drop role

2010-08-26 Thread Alvaro Herrera
Excerpts from Tom Lane's message of jue ago 26 14:59:43 -0400 2010: Alvaro Herrera alvhe...@commandprompt.com writes: Code is here: else if (deptype == SHARED_DEPENDENCY_ACL) appendStringInfo(descs, _(access to %s), objdesc); in StoreObjectDescription().

Re: [HACKERS] [ADMIN] Unable to drop role

2010-08-24 Thread Alvaro Herrera
Excerpts from Tom Lane's message of mar ago 24 09:36:05 -0400 2010: McGehee, Robert robert.mcge...@geodecapital.com writes: Thanks Tom and Alvaro for clearing up my confusion. \l showed that a485099 had both (C)reate and (T)emporary access. Revoking those allowed me to drop the role. Thanks

Re: [HACKERS] [ADMIN] Unable to drop role

2010-08-24 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Happy to change it to whatever is deemed appropriate. privileges for %s sounds good; I'll do that unless somebody comes up with a better idea which outvotes this one. Backpatch all the way to 8.1? Code doesn't exist prior to that. I'd vote

Re: [HACKERS] [ADMIN] Unable to drop role

2010-08-24 Thread Robert Haas
On Tue, Aug 24, 2010 at 1:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Happy to change it to whatever is deemed appropriate.  privileges for %s sounds good; I'll do that unless somebody comes up with a better idea which outvotes this one.