Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate comment on a table - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Duplicate comment on a table
Date
Msg-id CAKFQuwa_gdR8QLcsWmdtcU0EGwDfDu0ArOw4oJhXc55RFMvCsQ@mail.gmail.com
Whole thread Raw
In response to Duplicate comment on a table  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: Duplicate comment on a table
Next
From: Semab Tariq
Date:
Subject: Re: Technical Support