Postgres Pro
Downloads
Home   >   mailing lists

Re: How duplicate values inserted into the primary key column oftable and how to fix it - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How duplicate values inserted into the primary key column oftable and how to fix it
Date
Msg-id c43f6770-3907-bdc3-44c0-b9c89df9b571@aklaver.com
Whole thread Raw
In response to How duplicate values inserted into the primary key column of tableand how to fix it  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view 
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
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Casting Integer to Boolean in assignment
Next
From: Geoff Winkless
Date:
Subject: Re: Casting Integer to Boolean in assignment