Re: Duplicate data even with primary keys enabled

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


> On Oct 29, 2022, at 8:40 AM, Jayson Hreczuck <jayson.hreczuck@xxxxxxxxxxxxxxxxxxx> 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 was tricky, because it wasn't limited to just non-7-bit characters, but also how hyphens (or maybe it was underscores) were handled.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux