>> BTW, can you also resubmit the leakproof stuff as a separate patch for
>> the last CF? Want to make sure we get that into 9.2, if at all
> Yes, it shall be attached on the next message.
The attached patch adds LEAKPROOF attribute to pg_proc; that
enables DBA to set up obviously safe functions to be pushed down
into sub-query even if it has security-barrier attribute.
We assume this LEAKPROOF attribute shall be applied on operator
functions being used to upgrade execute plan from Seq-Scan to
The default is without-leakproof attribute on creation of functions,
and it requires superuser privilege to switch on.
KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp>
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2012-01-08 15:53:02|
|Subject: Re: Intermittent regression test failures from index-only
|Previous:||From: Jeff Janes||Date: 2012-01-08 15:42:13|
|Subject: Re: bgwriter holds onto file handles of deleted files|