Re: Mystery with REVOKE PRIVILEGE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Mystery with REVOKE PRIVILEGE
Date
Msg-id 1934014.1768950433@sss.pgh.pa.us
Whole thread Raw
In response to Re: Mystery with REVOKE PRIVILEGE  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Mystery with REVOKE PRIVILEGE
List pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> On Tue, Jan 20, 2026 at 04:32:31PM -0500, Tom Lane wrote:
>> I don't think "let's make select_best_grantor even more magic"
>> is the right approach.  IMO, if there is a GRANTED BY clause,
>> we should use exactly that grantor and not apply select_best_grantor
>> at all.  This is, for example, certainly the behavior needed for
>> pg_dump.

> I started on something like that here:
>     https://postgr.es/m/aRYLkTpazxKhnS_w%40nathan

Ah, I wonder if that discussion was lurking in my hindbrain.
I just posted a different take on how to do it in that thread,
but the behavioral change should be the same.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: [PATCH] Reserve protocol 3.1 explicitly in pqcomm.h
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Reserve protocol 3.1 explicitly in pqcomm.h