On Wednesday, September 8, 2021,
ldh@laurent-hasson.com <
ldh@laurent-hasson.com> wrote:
So, there are TWO records in the table pg_catalog.pg_description for a given table. I have no idea how this might have occurred and I know it “survives” a backup/restore. I am not sure how to fix this. It was suggested I vacuum full the table and reset the comment, but that didn’t work:
As Andrew just pointed out on the original JDBC thread OIDs are not global and the driver query doesn’t properly take that into account. The duplication seen here is actually two different objects with the same OID each having a single comment.
David J.