Re: Duplicate tables information through metadata queries

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Duplicate tables information through metadata queries
Дата
Msg-id CAKFQuwYD6TY4i78rZBzLB9eQSADL4uE++ZZ1WVwtVCRb6k8wEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Ответы RE: Duplicate tables information through metadata queries  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список 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 по дате отправления:

Предыдущее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: Duplicate tables information through metadata queries
Следующее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: RE: Duplicate tables information through metadata queries