Re: Indexing on JSONB field not working

On Fri, Dec 27, 2019 at 4:21 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Zhihong Zhang <zhihong(at)gmail(dot)com> writes:
> >> On Dec 27, 2019, at 12:45 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> 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