Re: Duplicate Key Values

Do you *currently* take regular backups?

We'd be glad to show you how to take regular logical backups.

On Tue, Mar 11, 2025 at 10:29 AM mark bradley <markbradyju(at)outlook(dot)com>
wrote:

> An "interesting" effect of reindexing is that all the records that were
> dups in the nodes table were deleted, both copies.
>
> Also, all rows having node_id as a foreign key in other tables were
> deleted, which means all rows in these tables were deleted.
>
> Fortunately these are not huge tables. I will reenter the data, make a
> backup, and then try your further extended suggestions.
>
> Best regards,
> Mark Brady
> *amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>*
> ------------------------------
> *From:* Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> *Sent:* Friday, March 7, 2025 3:25 PM
> *To:* mark bradley <markbradyju(at)outlook(dot)com>
> *Cc:* pgsql-general <pgsql-general(at)postgresql(dot)org>
> *Subject:* Re: Duplicate Key Values
>
> On 3/7/25 11:47, mark bradley wrote:
> > Wouldn't that be nice 🙂
>
> No, because you would end up with a mess.
>
> My AI rant:
>
> AI is neither artificial or intelligent. It is human code that pattern
> matches and then throws the matches against the wall and hope something
> sticks. It is left to the human to clean up.
>
> At any rate, in this post:
>
>
> https://www.postgresql.org/message-id/75b33741-ee99-4524-b63a-edad21c1266d%40aklaver.com
>
> You where provided an answer, which is further extended here:
>
>
> https://www.postgresql.org/message-id/CAKAnmm%2BBBBaXGN2xPHhXywkwb72UWzinWu2wQ5WadcMw3_57rQ%40mail.gmail.com
>
> >
> >
> > Best regards,
> > Mark Brady
> > _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
> > ------------------------------------------------------------------------
> > *From:* Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> > *Sent:* Friday, March 7, 2025 10:55 AM
> > *To:* mark bradley <markbradyju(at)outlook(dot)com>
> > *Cc:* pgsql-general <pgsql-general(at)postgresql(dot)org>
> > *Subject:* Re: Duplicate Key Values
> > On 3/7/25 06:34, mark bradley wrote:
> >> This is what MS Copilot has to say about this apparent bug where
> >> Postgres inserts extra rows violating a primary keys uniqueness
> constraint:
> >
> >
> >
> >> What to do? I hesitate to just delete my tables and start over because
> >> this error will reoccur.
> >
> > Let the AI solve it.
> >
> >>
> >> Best regards,
> >> Mark Brady
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>

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