On Wed, Mar 5, 2025 at 12:36 PM mark bradley <markbradyju@xxxxxxxxxxx> 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!