Re: A question about ExplainOnePlan() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A question about ExplainOnePlan()
Date
Msg-id 8570.1166028737@sss.pgh.pa.us
Whole thread Raw
In response to Re: A question about ExplainOnePlan()  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> On 12/13/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> No; at least not unless you want to duplicate the permission-checking
>> machinery inside ExecutorStart.

> I had seen the ExecCheckRTPerms() call inside InitPlan(), but didn't know
> that we considered even the EXPLAIN output to be so sensitive.

It's the same reason why pg_statistic isn't publicly readable.  The
standard example is that the min and max of an employee.salary column
are probably things that would be embarrassing to expose to everyone
in the company ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plan invalidation plans
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: unixware and --with-ldap