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