Request a Demo
Home   >   mailing lists

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

From Nathan Bossart
Subject Re: Mystery with REVOKE PRIVILEGE
Date
Msg-id aW_76boybYd_DpBJ@nathan
Whole thread Raw
In response to Re: Mystery with REVOKE PRIVILEGE  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Mystery with REVOKE PRIVILEGE
List pgsql-hackers
Tree view 
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

-- 
nathan

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Mystery with REVOKE PRIVILEGE
Next
From: Nathan Bossart
Date:
Subject: Re: Remove redundant AssertVariableIsOfType uses in pg_upgrade