Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role
Дата
Msg-id 031d60d1dcb869da4effe5e56411f8bdd01dd3a0.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: un-revert the MAINTAIN privilege and the pg_maintain predefined role
Список 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 по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Introduce XID age and inactive timeout based replication slot invalidation
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Re: pg16: XX000: could not find pathkey item to sort