| From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | invalid non-zero objectSubId for object class |
| Date: | 2020-07-09 23:10:27 |
| Message-ID: | CACxu=vLUD4WRwbFEGXTTdqqAiYTDn5JZ+R9cxJnsvQPpPffm=w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On a 12.3 AWS RDS instance, I get the following error when trying to drop
either of two tables:
dev=> drop table current_flight;
ERROR: invalid non-zero objectSubId for object class 297108
dev=> drop table flight;
ERROR: invalid non-zero objectSubId for object class 297108
I can create and drop new tables, but these two I cannot drop.
Both tables were at one point replicated using pglogical, but I've removed
them from their replication sets and nothing depends on them that I can
see. The replication of other tables is still proceeding normally.
Anyone have any thoughts on this? The db was also upgraded seemingly
successfully from 12.2 a couple of days ago and otherwise seems to be
working fine.
Thanks for any pointers!
-Michel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-07-09 23:18:00 | Re: invalid non-zero objectSubId for object class |
| Previous Message | Tim Cross | 2020-07-09 23:07:51 | Re: Efficiently advancing a sequence without risking it going backwards. |