Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role
Date
Msg-id 031d60d1dcb869da4effe5e56411f8bdd01dd3a0.camel@j-davis.com
Whole thread Raw
In response to Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role
List pgsql-hackers
On Tue, 2024-03-12 at 16:05 -0500, Nathan Bossart wrote:
> It's easy enough to resolve this inconsistency by sending
> down the parent OID when recursing to a TOAST table and using that
> for the
> privilege checks.  AFAICT this avoids any kind of cache lookup
> hazards
> because we hold a session lock on the main relation in this case. 
> I've
> done this in the attached v2.

Looks good to me. Thank you for expanding on the comment, as well.

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation
Next
From: Alexander Lakhin
Date:
Subject: Re: pg16: XX000: could not find pathkey item to sort