public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: mark bradley <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Duplicate Key Values
Date: Thu, 6 Mar 2025 12:00:58 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <SJ2PR22MB43281060E311F8B960869CE4BACA2@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]>
<SJ2PR22MB43281060E311F8B960869CE4BACA2@SJ2PR22MB4328.namprd22.prod.outlook.com>
On 3/6/25 10:36, mark bradley wrote:
Reply to list also.
Ccing list.
> 1) Did you not see duplicates with the old version of pgAdmin4?
> I did see it in my last update but have done a couple, so it should have
> happened then.
>
> 2) What do you see if you use psql?
> Here is the PSQL output:
Supply information as copy and paste text.
>
>
> 3) Did you upgrade/move the Postgres server or the underlying OS?
> No
>
> 4) Have you tried reindexing the node_id field?
> No, but I'll try that.
>
>
>
> Mark Brady,
> _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_
> ------------------------------------------------------------------------
> *From:* Adrian Klaver <[email protected]>
> *Sent:* Thursday, March 6, 2025 1:22 PM
> *To:* mark bradley <[email protected]>; Ron Johnson
> <[email protected]>; pgsql-general <[email protected]>
> *Subject:* Re: Duplicate Key Values
> On 3/6/25 10:11, mark bradley wrote:
>> Here is the table definition:
>>
>>
>> And here is the error message I get when I try to delete a duplicate:
>
> Please answer the following:
>
> 1) Did you not see duplicates with the old version of pgAdmin4?
>
> 2) What do you see if you use psql?
>
> 3) Did you upgrade/move the Postgres server or the underlying OS?
>
> 4) Have you tried reindexing the node_id field?
>
>>
>>
>> Mark Brady,
>> _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady
> <https://amazon.com/author/markjbrady>>_
>> ------------------------------------------------------------------------
>
> --
> Adrian Klaver
> [email protected]
>
--
Adrian Klaver
[email protected]
view thread (9+ 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], [email protected]
Subject: Re: Duplicate Key Values
In-Reply-To: <[email protected]>
* 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