MIME-Version: 1.0
References: <CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com>
In-Reply-To: <CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 5 Mar 2025 12:50:13 -0500
Message-ID: <CANzqJaDWzZ4O10QZi6w__N5q7gzwcZANfu0DxA7UOpFwqAqTyQ@mail.gmail.com>
Subject: Re: Duplicate Key Values
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000023a2b1062f9c06dd"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDWzZ4O10QZi6w__N5q7gzwcZANfu0DxA7UOpFwqAqTyQ%40mail.gmail.com>
Precedence: bulk

--00000000000023a2b1062f9c06dd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 5, 2025 at 12:36=E2=80=AFPM mark bradley <markbradyju@outlook.c=
om>
wrote:

> Although I did not enter them, somehow duplicate primary key values have
> appeared in one of my tables.
>

Is it a text/varchar column?  Has the distro been upgraded "recently", or
maybe streamed from an older Linux system to a newer Linux system?


> I can't remove the offending rows because the key is a foreign key in
> another table.
>
> What to do?
>

Are the records completely (i.e., all columns) identical?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 5, 2025 at 12:36=E2=80=AFPM m=
ark bradley &lt;<a href=3D"mailto:markbradyju@outlook.com">markbradyju@outl=
ook.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg-39130=
65403434100337">


<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Although I did not enter them, somehow duplicate primary key values have ap=
peared in one of my tables.=C2=A0 </div></div></div></blockquote><div><br><=
/div><div>Is it a text/varchar column?=C2=A0 Has the distro been upgraded &=
quot;recently&quot;, or maybe streamed from an older Linux system to a newe=
r Linux system?</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div class=3D"msg-3913065403434100337"><div dir=3D"ltr"><div s=
tyle=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,He=
lvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">I can&#39;t remove the =
offending rows because the key is a foreign key in another table.</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
What to do?</div></div></div></blockquote><div></div></div><div><br></div><=
div>Are the records completely (i.e., all columns) identical?</div><div><br=
></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr=
" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and=
 butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt=
;Redacted&gt; lobster!</div></div></div></div></div></div>

--00000000000023a2b1062f9c06dd--