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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Derek Hans <derek(dot)hans(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: GIST/GIN index not used with Row Level Security
Date: 2019-08-13 21:22:06
Message-ID: 4621.1565731326@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Derek Hans <derek(dot)hans(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2019-08-13 21:39:30 Re: GIST/GIN index not used with Row Level Security
Previous Message Derek Hans 2019-08-13 21:04:33 Re: GIST/GIN index not used with Row Level Security