Re: REASSIGN OWNED doesn't know how to deal with USER MAPPINGs

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jaime Casanova <jaime(dot)casanova(at)2ndquadrant(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: REASSIGN OWNED doesn't know how to deal with USER MAPPINGs
Date: 2015-12-11 21:47:57
Message-ID: 20151211214757.GU2763@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jaime Casanova wrote:
> On 10 December 2015 at 13:04, Jaime Casanova
> <jaime(dot)casanova(at)2ndquadrant(dot)com> wrote:
> > Hi,
> >
> > We just notice $SUBJECT. Attached patch fixes it by ignoring USER
> > MAPPINGs in shdepReassignOwned() just like it happens with default
> > ACLs.

Yep, I had already posted this patch elsewhere, and I just pushed it.

> BTW, shouldn't we at least give a warning on those cases instead of
> asuming that the user will know that some objects were ignored?

I don't think so. This kind of thing is supposed to silent when nothing
is to be done.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Dilger 2015-12-11 22:24:40 Re: Bootstrap DATA is a pita
Previous Message Tom Lane 2015-12-11 21:46:42 Re: Bootstrap DATA is a pita