Re: GIST/GIN index not used with Row Level Security

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GIST/GIN index not used with Row Level Security
Дата
Msg-id 4621.1565731326@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GIST/GIN index not used with Row Level Security  (Derek Hans <derek.hans@gmail.com>)
Список pgsql-general
Derek Hans <derek.hans@gmail.com> writes:
> Unfortunately only "alter function" supports "leakproof" - "alter operator"
> does not. Is there a function-equivalent for marking operators as
> leakproof?

Leakproofness is a property of the underlying function, not the operator,
so that's where you change it.

> Is there any documentation for which operators/functions are
> leakproof?

select oid::regprocedure from pg_proc where proleakproof;

            regards, tom lane



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

Предыдущее
От: Derek Hans
Дата:
Сообщение: Re: GIST/GIN index not used with Row Level Security
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: GIST/GIN index not used with Row Level Security