Sounds like you need a unique constraint on the PK field. The duplicate values may be inserted if the sequence on the PK is out of sync (if there is a sequence providing values for the PK).
On 1/24/19 4:46 AM, Raghavendra Rao J S V wrote: Hi All, We are using Postgresql 9.2 database. In one of the transactional table, I have observed duplicate values for the primary key columns. Best guess a corrupted index. As Hellmuth said more information would be helpful. Please guide me how is it possible and how to fix this kind of issue. -- Regards, Raghavendra Rao J S V
Hi All, We are using Postgresql 9.2 database. In one of the transactional table, I have observed duplicate values for the primary key columns.
Please guide me how is it possible and how to fix this kind of issue. -- Regards, Raghavendra Rao J S V
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных