Re: BUG #18504: More than one row with the same Primary Key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: z(dot)chouk(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18504: More than one row with the same Primary Key
Date: 2024-06-11 19:01:17
Message-ID: 1052707.1718132477@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-06-11 20:22:39 BUG #18505: while installation of postgresql ,getting warning by selecting postresql 16 on port 5432
Previous Message PG Bug reporting form 2024-06-11 14:02:42 BUG #18504: More than one row with the same Primary Key