From: mark bradley <markbradyju@outlook.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Duplicate Key Values
Thread-Topic: Duplicate Key Values
Thread-Index: AQHbjfSQTi8IT+qnIE+vrsDEftWkng==
Date: Wed, 5 Mar 2025 17:35:50 +0000
Message-ID:
 <CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: CH3PR22MB4312:EE_|PH7PR22MB3868:EE_
x-ms-office365-filtering-correlation-id: 89765e27-9e64-4fe9-422e-08dd5c0c2c49
x-microsoft-antispam:
 BCL:0;ARA:14566002|15030799003|8062599003|19110799003|461199028|8060799006|7092599003|9400799030|12050799009|15080799006|10035399004|4302099013|3412199025|440099028|41001999003|102099032|1602099012;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?pBatsQRbR8lqzusGWcRd1RAHviLncYyaMNzsrO5LQCIOTGHC+L1BPlrF1j?=
 =?iso-8859-1?Q?Iamffsn9eqn998XqsozWgWBHCPABkyvNqqot0zivGUD3aYEVT7/GA0/hVz?=
 =?iso-8859-1?Q?iDEoj7DWHBnrt9gaPDOtx4ldiuGHOpEHbBl1OuJNwYWFS6UMc0NzvysF1z?=
 =?iso-8859-1?Q?MZgHrSD5uq+Vm4GbpOoyw4xlx/YUrzlW9Ag+oK/C4alFHAx3F1XISS1MCv?=
 =?iso-8859-1?Q?oIqn4esYFUMiSqw0jUshBwJ8Pk2PtzUbVZTT1WPtzgQ2v2Fz5hshyfzWmy?=
 =?iso-8859-1?Q?Kvs5PfE666l3lwc/OvNt9QAj/KiPzKxlRyZErh71+pj4GjnazEO1L3t8Ic?=
 =?iso-8859-1?Q?ZmmyC/Er5IN8TTZcd2mOeJ741EbEn1eCGWiCN96JaNWbtFSPlRx2waxj1F?=
 =?iso-8859-1?Q?qytshS1sJD7kcIhG3Cgm7iPw4lejdPhGZfTXGz2PIQiu3YD6RhYQuUtV7n?=
 =?iso-8859-1?Q?zy7hvc0Q74WOFw2ws2PLp/Tv+8b+K9uQ60LOAmbFQCKdo5N8QPEYH/Y9QL?=
 =?iso-8859-1?Q?3CYQomOQROkCIs0SYqc0NtWVtrdVD7mq/jwT+rRJxEqaS7HCfsYBmB/2HD?=
 =?iso-8859-1?Q?sqnThBrPU+llgtMQPRNol+IiwYCZR+WUOHm0xWJdI/Xj6ueL2d4C/pUGHJ?=
 =?iso-8859-1?Q?PrBk7YT8Z7qwwZ4O4Mdv1by2GbF6e+FBVWk8Kd+Xs+bknz6PquOCdwLVbc?=
 =?iso-8859-1?Q?SAOdh9xXNzl8yjbzjvb1iV4QrYPRgmMw6ZrfEPWzoBxJM/GC/qBc5Jz0df?=
 =?iso-8859-1?Q?nHdB0u/vwHss/NHfs1q4XxqFXnW2QLCLi7GUypeab07goVPy7TNT/nmNXZ?=
 =?iso-8859-1?Q?/S1RMMBP1LT3COfxtK8gs136UyjJvGjbDZPRU42gWDHt62IUIgSP70LUqY?=
 =?iso-8859-1?Q?KkLJRJJe4r7NJJQZygaQDZA9IVgsMCyPoqNd0iqsGUOVawnTv4Ce3ZM1jQ?=
 =?iso-8859-1?Q?PkLFIXZfcc3rvogiqVqftvcF77E9XWvCos1q8mKk05k00cNk7zJqn6/TGS?=
 =?iso-8859-1?Q?kP/SP8tuTrjXrVz4Gxs3FD6iKyBUnbMlZIInsLgTdXp2KSg/wBxBEM5GIg?=
 =?iso-8859-1?Q?N8YK8xuwxLJj/dXzVZgmxxSRk9WkK+NcG8plsMs9P4g1hJGzat68/rMfRR?=
 =?iso-8859-1?Q?es6k0o7VEhLvm442Xny8KcgFPShYkDo1hoToQL5r2a5ZT+zwRDCDhzxlg1?=
 =?iso-8859-1?Q?E263d6oVRXyMP1XB/8GpUi+IYHOP8mOPZg6V5eTZiN5NzoI+xK0QOWBvov?=
 =?iso-8859-1?Q?FaFSTIi9WYoDVAcgiU6XfSvcoK4Vd/UV8vwSjBVGrL5RA1YzxYS73GG+7l?=
 =?iso-8859-1?Q?FuNYN8/pEfqkekg8aHLRMBlPb61TVHgZ21bQT1ebhSQcxIkkDCHEcJTZIu?=
 =?iso-8859-1?Q?MMg+gpQhHd?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?oTLW0Hw+4nbAulrYxJ7mOeVpeR9hdIsvHQ3ugcO93W/p7SHjDfcjMIruTD?=
 =?iso-8859-1?Q?cuFMC4jL/Gf0q2FEF4MeT07dNNHRLTZW+KgMTq8ShXMJ+QiX8IvA/rWX/9?=
 =?iso-8859-1?Q?Wi7jGHJVJVM8ofZe7b7qu+O0miJJSicUTiLvYqL0X//gnz3mHQ2DzRhqY6?=
 =?iso-8859-1?Q?pptQ9mG5nAgtO37iwGzMzdr+y+X3XIIuwEPry7mvUrisBOvkGxGpP+8cx4?=
 =?iso-8859-1?Q?A2l9cYSHqvsBjSvJ00dYwtAh/LvSOUpg/EyVBLHpCHPuPtTHcIbPLDU/fe?=
 =?iso-8859-1?Q?B5UMpKImDkoRIjvqVMovVrjLEiZ4OU1IilLeyQ38n2Cq7yPHql9m/Y6IYe?=
 =?iso-8859-1?Q?c6n5spKutrOCBazOHUopAonZuTlAvkl1Xa8Llcr4A8FPMVNmb+c6tud/I8?=
 =?iso-8859-1?Q?28AiZkAuwuNXjMIT+N8WaHucfrJngwzdLJKWdJ6JVet6R0gUfh1WxjKj6y?=
 =?iso-8859-1?Q?d6aYpUVTvVQp5pU1x6OzoDs+sPfdrUqG4S6zGU9Q0cPOzdV3n9z/bsUTCV?=
 =?iso-8859-1?Q?jnppDbtVTB2owZvQydBjm0pr1VnkhIIh1899eDd/pfGHkEpo7D4xm3mNVj?=
 =?iso-8859-1?Q?brmhDgpR41U5EyrA0LPKbrOCr1p/s93uCtzkNPFE8jOHJTq933s86YftmR?=
 =?iso-8859-1?Q?Mat07Dsd5jo4+gC+O5G7kij62BWVIz+5OBuY0wIyBiRidWiDyB6UFPCJ9X?=
 =?iso-8859-1?Q?KIz769jrHvnUD1R30/tXM1mMJej6x0Rm6w0PEa/tOBOtNh7xe5B4eon3wJ?=
 =?iso-8859-1?Q?EMMGC58Ayf9PNDxmyMfQR+pqIUvx8B/2Y61Gqch5YNpxSxddAt0Omb6q/2?=
 =?iso-8859-1?Q?rmf80UkAYmUgNQcD2QUKhvcdQWXyrsjny/sv9aTlEAvYw70R8F/Fuozj5M?=
 =?iso-8859-1?Q?G4x2J7epe1rjSQPB2tj8A/Q8pIvhuBG80OKZe9cbx3M7N678CWZfLkf1q7?=
 =?iso-8859-1?Q?7OiyuWifHJ5cEGJm10U9LvyG1qfwD0NScxqPNueKLbwKZFuQAh4NmeUGCK?=
 =?iso-8859-1?Q?C1DEc0rK+vbWwRRh2LHb630VNcLMRfxJQvPp8nbzfxT8R54L0eTv84Kwzk?=
 =?iso-8859-1?Q?xfLY/4YxIZxfNozviwwFB0D3Dblf6q9S72XamC+qQx5EF5xBWpuJNy+wrV?=
 =?iso-8859-1?Q?1aHmPg/jD0B6ekZE4ju9HfSfM6cGAhffNSBPU+4bmIaQKmZWAjnnH72QDM?=
 =?iso-8859-1?Q?io0BsoM8DvDxSGk1fJNnDpTwzxEzFoC7Yj2XfBrKblxMngJqyKJ5Gim57M?=
 =?iso-8859-1?Q?9pLA0Rn+/PN5EOlzv74zUcfBhY23MF+pNSh26cUE8=3D?=
Content-Type: multipart/alternative;
	boundary="_000_CH3PR22MB4312C23476C0E67F9B4C2E10BACB2CH3PR22MB4312namp_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: CH3PR22MB4312.namprd22.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 89765e27-9e64-4fe9-422e-08dd5c0c2c49
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Mar 2025 17:35:50.8310
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH7PR22MB3868
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CH3PR22MB4312C23476C0E67F9B4C2E10BACB2%40CH3PR22MB4312.namprd22.prod.outlook.com>
Precedence: bulk

--_000_CH3PR22MB4312C23476C0E67F9B4C2E10BACB2CH3PR22MB4312namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Although I did not enter them, somehow duplicate primary key values have ap=
peared in one of my tables.  I can't remove the offending rows because the =
key is a foreign key in another table.

What to do?

Mark Brady,
amazon.com/author/markjbrady<https://amazon.com/author/markjbrady>

--_000_CH3PR22MB4312C23476C0E67F9B4C2E10BACB2CH3PR22MB4312namp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Although I did not enter them, somehow duplicate primary key values have ap=
peared in one of my tables.&nbsp; I can't remove the offending rows because=
 the key is a foreign key in another table.</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
What to do?</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div id=3D"Signature" class=3D"elementToProof">
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Mark Brady,&nbsp;</div>
<div style=3D"font-family: &quot;Amazon Ember&quot;, Arial, Helvetica, sans=
-serif; font-size: 15px; color: rgb(16, 67, 77);">
<span style=3D"background-color: rgb(251, 251, 249); line-height: 1.25; fon=
t-weight: 700;"><u><a href=3D"https://amazon.com/author/markjbrady" target=
=3D"_blank" class=3D"css-1eeomzs-base-styles" rel=3D"noopener" data-gui-nam=
e=3D"Link" style=3D"color: rgb(16, 67, 77); background-color: rgb(251, 251,=
 249); text-align: left;">amazon.com/author/markjbrady</a></u></span></div>
</div>
</body>
</html>

--_000_CH3PR22MB4312C23476C0E67F9B4C2E10BACB2CH3PR22MB4312namp_--