Re: Indexing on JSONB field not working

On Fri, Dec 27, 2019 at 4:21 PM Tom Lane <[email protected]> wrote:

> Zhihong Zhang <[email protected]> writes:
> >> On Dec 27, 2019, at 12:45 PM, Jeff Janes <[email protected]> wrote:
> >> Can you do  `pg_dump -s -t assets ...` to get a full description of the
> table?  If you don't want to share the full description, make sure whatever
> simplifications you do to it don't prevent the problem from reproducing.
>
> > I created a new table ‘assets_copy’ with only 3 columns. I can still
> reproduce the problem. The pg_dump output is attached.
>
> I'm a little suspicious of this because it says the table owner is
> "postgres", but you say you're not superuser.  Does RDS create a
> non-superuser "postgres" account?
>

Yes, the default setting for RDS is to have a user named "postgres" which
is as-super-as RDS allows you to get.

Cheers,

Jeff