| From: | Jayson Hreczuck <jayson(dot)hreczuck(at)studentuniverse(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | abbas alizadeh <ramkly(at)yahoo(dot)com>, Erik Wienhold <ewie(at)ewie(dot)name>, Teju Jakkidi vlogs <teja(dot)jakkidi05(at)gmail(dot)com>, Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Duplicate data even with primary keys enabled |
| Date: | 2022-10-29 14:40:54 |
| Message-ID: | CAHg7=h7hGMWvbhrq6hbQmzX8pEN6_Fp_FmTX8Wy70Yjk=aJ4cQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)elevated-dev(dot)com>
wrote:
> Actual table definition, sample query, and output, please.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Oct 29, 2022, at 5:20 AM, abbas alizadeh <ramkly(at)yahoo(dot)com> wrote:
> >
> > I faced the same issue last week.
> > We had duplicated records on primary key.
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samed YILDIRIM | 2022-10-29 14:47:20 | Re: Duplicate data even with primary keys enabled |
| Previous Message | Scott Ribe | 2022-10-29 12:16:01 | Re: Duplicate data even with primary keys enabled |