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.klaver@xxxxxxxxxxx>
*Sent:* Thursday, March 6, 2025 1:22 PM
*To:* mark bradley <markbradyju@xxxxxxxxxxx>; Ron Johnson
<ronljohnsonjr@xxxxxxxxx>; pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
*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.klaver@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
