Re: Indexing on JSONB field not working

I created the index myself using the same account. Should I be the owner?

Zhihong

> On Dec 26, 2019, at 6:51 PM, Tom Lane <[email protected]> wrote:
> 
> Tomas Vondra <[email protected]> writes:
>> On Thu, Dec 26, 2019 at 05:25:22PM -0500, Zhihong Zhang wrote:
>>> I am not superuser. Let me see how I can get access to the superuser on RDS.
> 
>> You can't - that's the point of am environment managed by someone else.
>> Perhaps you could inspect the data directly in pg_statistic, not through
>> the pg_stats view. But I haven't tried if that works on RDS.
> 
> He definitely shouldn't be able to do that, if not superuser.
> 
> However, after experimenting a bit it seems like pg_stats does work for
> indexes as long as you are the owner of the index's table, which probably
> explains why it took so long for anybody to notice the problem.  Maybe the
> OP is trying to look at the stats as a non-owner that's just been GRANT'ed
> table access?
> 
> 			regards, tom lane