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 8:30 AM, Adrian Klaver wrote:
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