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

From Scott Ribe
Subject Re: Duplicate data even with primary keys enabled
Date
Msg-id 0E92AFA3-CD35-4B25-90AE-D1E46420E90B@elevated-dev.com
Whole thread Raw
In response to Re: Duplicate data even with primary keys enabled  (Jayson Hreczuck <jayson.hreczuck@studentuniverse.com>)
List pgsql-admin
> On Oct 29, 2022, at 8:40 AM, Jayson Hreczuck <jayson.hreczuck@studentuniverse.com> wrote:
>
> 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. 

I've seen it once because of bad hardware, and once because of collation changes with a Linux upgrade. That latter one
wastricky, because it wasn't limited to just non-7-bit characters, but also how hyphens (or maybe it was underscores)
werehandled. 


pgsql-admin by date:

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