Обсуждение: 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
От
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
Raghavendra Rao J S V
Re: How duplicate values inserted into the primary key column oftable and how to fix it
От
Hellmuth Vargas
Дата:
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
От
Hellmuth Vargas
Дата:
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
От
Adrian Klaver
Дата:
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
От
Adrian Klaver
Дата:
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