| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| 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 |
| Date: | 2025-03-06 18:22:05 |
| Message-ID: | 6aee94f9-d421-4622-bccc-bdac37969be0@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>_
> ------------------------------------------------------------------------
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-03-06 20:00:58 | Re: Duplicate Key Values |
| Previous Message | Ron Johnson | 2025-03-06 18:16:56 | Re: Quesion about querying distributed databases |