Horton

Re: BUG #17346: pg_upgrade fails with role granted by other role

Daniel Gustafsson <daniel@yesql.se>

View thread View on postgr.es
From: Daniel Gustafsson <daniel@yesql.se>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org, Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Date: 2021-12-29T22:17:29Z
Lists: pgsql-bugs

Attachments

> On 28 Dec 2021, at 00:26, Daniel Gustafsson <daniel@yesql.se> wrote:

> I'll craft a revert of b2a459edf when I'm less tired, a proper fix can then be
> worked on separately.

I prepared a revert patch tonight and ran it through CI, but won't have ample
time to monitor the buildfarm so I have it slated for pushing in the morning.
I opted for keeping the tests even though they aren't excercising all that much
code but they at least show the current behavior.

--
Daniel Gustafsson		https://vmware.com/

Commits

  1. Revert b2a459edf "Fix GRANTED BY support in REVOKE ROLE statements"

  2. Fix GRANTED BY support in REVOKE ROLE statements

  3. Allow GRANTED BY clause in normal GRANT and REVOKE statements