Duplicate Key Values

From: mark bradley <markbradyju(at)outlook(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Duplicate Key Values
Date: 2025-03-05 17:35:50
Message-ID: CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Although I did not enter them, somehow duplicate primary key values have appeared 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>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2025-03-05 17:49:53 Re: Error on query execution
Previous Message Marc Millas 2025-03-05 16:34:31 Re: end of COPY