Re: GIST/GIN index not used with Row Level Security - Mailing list pgsql-general

From Tom Lane
Subject Re: GIST/GIN index not used with Row Level Security
Date
Msg-id 4621.1565731326@sss.pgh.pa.us
Whole thread Raw
In response to Re: GIST/GIN index not used with Row Level Security  (Derek Hans <derek.hans@gmail.com>)
List 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 by date:

Previous
From: Derek Hans
Date:
Subject: Re: GIST/GIN index not used with Row Level Security
Next
From: Stephen Frost
Date:
Subject: Re: GIST/GIN index not used with Row Level Security