Thread: How duplicate values inserted into the primary key column of tableand how to fix it
How duplicate values inserted into the primary key column of tableand how to fix it
From
Raghavendra Rao J S V
Date:
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
Raghavendra Rao J S V
Re: How duplicate values inserted into the primary key column oftable and how to fix it
From
Hellmuth Vargas
Date:
Hi
you could provide the definition of the table that includes the definition of the primary key?
El jue., 24 de ene. de 2019 a la(s) 09:18, Raghavendra Rao J S V (raghavendrajsv@gmail.com) escribió:
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
Cordialmente,
Ing. Hellmuth I. Vargas S.
Ing. Hellmuth I. Vargas S.
Re: How duplicate values inserted into the primary key column oftable and how to fix it
From
Hellmuth Vargas
Date:
Hi
you could provide the definition of the table that includes the definition of the primary key?
El jue., 24 de ene. de 2019 a la(s) 09:18, Raghavendra Rao J S V (raghavendrajsv@gmail.com) escribió:
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
Cordialmente,
Ing. Hellmuth I. Vargas S.
Ing. Hellmuth I. Vargas S.
Re: How duplicate values inserted into the primary key column oftable and how to fix it
From
Adrian Klaver
Date:
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
Re: How duplicate values inserted into the primary key column oftable and how to fix it
From
Adrian Klaver
Date:
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