Home > mailing lists

Re: Duplicate Key Values - Mailing list pgsql-general

From	Ron Johnson
Subject	Re: Duplicate Key Values
Date	March 5 20:50:13
Msg-id	CANzqJaDWzZ4O10QZi6w__N5q7gzwcZANfu0DxA7UOpFwqAqTyQ@mail.gmail.com Whole thread Raw
In response to	Duplicate Key Values (mark bradley <markbradyju@outlook.com>)
List	pgsql-general

On Wed, Mar 5, 2025 at 12:36 PM mark bradley <markbradyju@outlook.com> 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?

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> lobster!

From: mark bradley
Date: 05 March, 20:35:50
Subject: Duplicate Key Values

From: Igor Korot
Date: 06 March, 02:10:30
Subject: Re: Error on query execution