Petr Jelinek escribió: > Petr Jelinek napsal(a): > >Tom Lane napsal(a): > >>Petr Jelinek <pjmo...@pjmodos.net> <mailto:pjmo...@pjmodos.net> writes: > >>>Tom Lane napsal(a): > >>>>One thing that seems like it's likely to be an annoyance in practice > >>>>is the need to explicitly do DROP OWNED BY to get rid of pg_default_acl > >>>>entries for a role to be dropped. > >>>Yeah I am not happy about this either but there is not much we > >>>can do about it. Btw I think in the version I sent in REASSIGN > >>>OWNED acted as DROP OWNED for default ACLs. > >>IIRC it just threw a warning, which didn't seem tremendously useful to > >>me. > > > >Oh did it ? Then I must have discarded that idea for some reason. > >I probably didn't want to be too pushy there. > > Now I remember why - consistency with ACLs on object. REASSIGN OWNED > does not drop any GRANTed ACLs on any object, so it seemed > appropriate to only drop default ACLs in DROP OWNED BY along with > ACLs on objects.
That seems reasonable to me too ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers