MIME-Version: 1.0
From: shashidhar Reddy <shashidharreddy001@gmail.com>
Date: Mon, 25 Nov 2024 12:00:55 +0530
Message-ID: <CAH=zU4t3KRpt6uTZn_4eKkvpL_X9ACGNZ+XDxfMjnn6ovAyPVQ@mail.gmail.com>
Subject: Unique key constraint Issue
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a53a510627b6e0d8"
Archived-At: <https://www.postgresql.org/message-id/CAH%3DzU4t3KRpt6uTZn_4eKkvpL_X9ACGNZ%2BXDxfMjnn6ovAyPVQ%40mail.gmail.com>
Precedence: bulk

--000000000000a53a510627b6e0d8
Content-Type: text/plain; charset="UTF-8"

Hello,

We have postgresql servers with PostgreSQL 13.10   on Ubuntu release 22.04.

The issue is a unique key constraint with two columns one is character
another is integer. At some point the unique key did not work as I see
duplicate values with these two columns combination and it happened on
multiple servers on multiple databases on same table with same unique key.
I tried db dump and restore but the key is failing to create when restore
with duplicate value errors.

--000000000000a53a510627b6e0d8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"auto">Hello,</div><div dir=3D"auto"><br></div=
><div dir=3D"auto">We have postgresql servers with PostgreSQL 13.10=C2=A0 =
=C2=A0on Ubuntu release 22.04.</div><div dir=3D"auto"><br></div><div dir=3D=
"auto">The issue is a unique key constraint with two columns one is charact=
er another is integer. At some=C2=A0point the unique key did=C2=A0not work =
as I see duplicate values with these two columns combination and it happene=
d on multiple servers on multiple databases on same table with same unique =
key. I tried db dump and restore but the key is failing to create when rest=
ore with duplicate value errors.</div><div dir=3D"auto"><br></div><div dir=
=3D"auto"><br></div><div dir=3D"auto"><br></div></div>

--000000000000a53a510627b6e0d8--