public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Duplicate Key Values
Date: Tue, 11 Mar 2025 10:40:11 -0400
Message-ID: <CANzqJaC9oF+NSTZ=oEFu6ao2q5HpjHQV59muieB9rYWCFMAEvA@mail.gmail.com> (raw)
In-Reply-To: <SJ2PR22MB4328C3D2704FB8F6CD079924BAD12@SJ2PR22MB4328.namprd22.prod.outlook.com>
References: <CH3PR22MB4312C23476C0E67F9B4C2E10BACB2@CH3PR22MB4312.namprd22.prod.outlook.com>
<CANzqJaDWzZ4O10QZi6w__N5q7gzwcZANfu0DxA7UOpFwqAqTyQ@mail.gmail.com>
<SJ2PR22MB43284AE4E32208EB035F68F5BACB2@SJ2PR22MB4328.namprd22.prod.outlook.com>
<CANzqJaCZefaoZqJzPSFqEaRA1W-Ps5E6yNuL_PT-WxUw9x38Nw@mail.gmail.com>
<[email protected]>
<SJ2PR22MB4328C53DB4397EB9759419DDBACA2@SJ2PR22MB4328.namprd22.prod.outlook.com>
<[email protected]>
<SJ2PR22MB4328C88FCBA2B447CC72DC90BACA2@SJ2PR22MB4328.namprd22.prod.outlook.com>
<[email protected]>
<SJ2PR22MB4328931B7CB951A48F1434ABBACA2@SJ2PR22MB4328.namprd22.prod.outlook.com>
<[email protected]>
<SJ2PR22MB43286857EAC74D1EE332B08CBAD52@SJ2PR22MB4328.namprd22.prod.outlook.com>
<[email protected]>
<SJ2PR22MB43282F7C60DD81CA90502FA0BAD52@SJ2PR22MB4328.namprd22.prod.outlook.com>
<[email protected]>
<SJ2PR22MB4328C3D2704FB8F6CD079924BAD12@SJ2PR22MB4328.namprd22.prod.outlook.com>
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 <[email protected]>
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 <[email protected]>
> *Sent:* Friday, March 7, 2025 3:25 PM
> *To:* mark bradley <[email protected]>
> *Cc:* pgsql-general <[email protected]>
> *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.g...
>
> >
> >
> > Best regards,
> > Mark Brady
> > _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
> > ------------------------------------------------------------------------
> > *From:* Adrian Klaver <[email protected]>
> > *Sent:* Friday, March 7, 2025 10:55 AM
> > *To:* mark bradley <[email protected]>
> > *Cc:* pgsql-general <[email protected]>
> > *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
> > [email protected]
> >
>
> --
> Adrian Klaver
> [email protected]
>
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (25+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Duplicate Key Values
In-Reply-To: <CANzqJaC9oF+NSTZ=oEFu6ao2q5HpjHQV59muieB9rYWCFMAEvA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox