Re: Duplicate tables information through metadata queries - Mailing list pgsql-jdbc

From David G. Johnston
Subject Re: Duplicate tables information through metadata queries
Date
Msg-id CAKFQuwYD6TY4i78rZBzLB9eQSADL4uE++ZZ1WVwtVCRb6k8wEQ@mail.gmail.com
Whole thread Raw
In response to Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Responses RE: Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
List pgsql-jdbc
On Wednesday, September 8, 2021, ldh@laurent-hasson.com <ldh@laurent-hasson.com> wrote:


The only difference I saw was in the “remarks” for the two tables, with one of them saying "btree comparison function" which is strange.



This would seem to indicate that the catalog pg_description has two rows for this particular table and thus the join to it [1] causes the single pg_class entry to become duplicated.

Per the comment command page each object gets at most one comment so having multiples in the catalog is data corruption.  If you confirm that you do indeed have duplicates hopefully issuing create comment on the problematic records clears up the issue.

David J.



pgsql-jdbc by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: Duplicate tables information through metadata queries
Next
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Duplicate tables information through metadata queries