Re: Duplicate Key Values

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 <adrian(dot)klaver(at)aklaver(dot)com>
> *Sent:* Thursday, March 6, 2025 1:22 PM
> *To:* mark bradley <markbradyju(at)outlook(dot)com>; Ron Johnson
> <ronljohnsonjr(at)gmail(dot)com>; pgsql-general <pgsql-general(at)postgresql(dot)org>
> *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
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com