Re: [Patch] Invalid permission check in pg_stats for functionalindexes

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: [Patch] Invalid permission check in pg_stats for functionalindexes
Дата
Msg-id 321f3da1-8b79-7866-69ea-f54e20264363@pgmasters.net
обсуждение исходный текст
Ответ на Re: [Patch] Invalid permission check in pg_stats for functional indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [Patch] Invalid permission check in pg_stats for functional indexes  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-hackers
Hi Pierre,

On 12/26/19 6:46 PM, Tom Lane wrote:
> Awhile back I wrote:
>> Actually ... maybe we don't need to change the view definition at all,
>> but instead just make has_column_privilege() do something different
>> for indexes than it does for other relation types.  It's dubious that
>> applying that function to an index yields anything meaningful today,
>> so we could redefine what it returns without (probably) breaking
>> anything.  That would at least give us an option to back-patch, too,
>> though the end result might be complex enough that we don't care to
>> risk it.
> 
> In hopes of resurrecting this thread, here's a draft patch that does
> it like that (and also fixes row_security_active(), as otherwise this
> probably creates a security hole in pg_stats).

Do you know when you will have a chance to look at this patch?

Tom made a suggestion up-thread about where the regression tests could go.

Regards,
-- 
-David
david@pgmasters.net



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Berserk Autovacuum (let's save next Mandrill)
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Berserk Autovacuum (let's save next Mandrill)