BUG #18504: More than one row with the same Primary Key
The following bug has been logged on the website:
Bug reference: 18504
Logged by: Zied CHOUK
Email address: z.chouk@gmail.com
PostgreSQL version: 13.15
Operating system: Alpine Linux 3.18.4
Description:
We have a table with a primary key of type String, we noticed that we have
more than one row with the same primary key.
PG Bug reporting form <noreply@postgresql.org> writes:
We have a table with a primary key of type String, we noticed that we have
more than one row with the same primary key.
Most likely this happened because the primary key index became corrupt
due to a change in the underlying system's sort ordering. This page
has some info about that type of problem:
https://wiki.postgresql.org/wiki/Locale_data_changes
regards, tom lane