Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing on JSONB field not working - Mailing list pgsql-bugs

From Tomas Vondra
Subject Re: Indexing on JSONB field not working
Date
Msg-id 20191226234124.wuarzcbdq5z5msiy@development
Whole thread Raw
In response to Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
Responses Re: Indexing on JSONB field not working  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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.


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Zhihong Zhang
Date:
Subject: Re: Indexing on JSONB field not working
Next
From: Tom Lane
Date:
Subject: Re: Indexing on JSONB field not working