Re: BUG #17173: Primary Key ignored resulting in duplicate values

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17173: Primary Key ignored resulting in duplicate values
Дата
Msg-id CAKFQuwYqwn+GVZPDOjS5seQEvG3yEDxpkZjSUX+bxbv4=xoLyg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17173: Primary Key ignored resulting in duplicate values  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Wed, Sep 1, 2021 at 4:44 AM PG Bug reporting form <noreply@postgresql.org> wrote:
    CONSTRAINT priceupdate_pkey PRIMARY KEY (id)
        USING INDEX TABLESPACE pgwlicsdb

We have other tables that also have duplicates for primary key.

Could you please provide feedback with regards to my query.


Remove the duplicates and then reindex the backing unique index.

If the duplicates are being created while running a supported version of PostgreSQL, and they are all using the same tablespace, consider that it is good odds whatever filesystem your tablespace is on may have issues.  As you don't seem to be using a supported version you should probably fix that deficiency first though, and see whether new problematic records get created in the future.

David J.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09
Следующее
От: Ram Pratap Maurya
Дата:
Сообщение: RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09