Re: Duplicate data even with primary keys enabled - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Duplicate data even with primary keys enabled
Date
Msg-id CAHg7=h7hGMWvbhrq6hbQmzX8pEN6_Fp_FmTX8Wy70Yjk=aJ4cQ@mail.gmail.com
Whole thread Raw
In response to Re: Duplicate data even with primary keys enabled  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Duplicate data even with primary keys enabled  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Very curious about this too.  Corruption of indexes does occur but less than a handful of times in my 30 years of DBA experience, and is usually due to hardware failure or some immediate cause.

Script the table and provide the query.


On Sat, Oct 29, 2022, 8:16 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
Actual table definition, sample query, and output, please.

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Oct 29, 2022, at 5:20 AM, abbas alizadeh <ramkly@yahoo.com> wrote:
>
> I faced the same issue last week.
> We had duplicated records on primary key.



pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Duplicate data even with primary keys enabled
Next
From: Samed YILDIRIM
Date:
Subject: Re: Duplicate data even with primary keys enabled