Re: Duplicate Key Values - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Duplicate Key Values
Date
Msg-id CAKAnmmLQA3+vqZg9wPq37SJPNfD0+LMqOofhH2DZaB6qfDTE8g@mail.gmail.com
Whole thread Raw
In response to Re: Duplicate Key Values  (mark bradley <markbradyju@outlook.com>)
List pgsql-general
On Tue, Mar 11, 2025 at 10:29 AM mark bradley <markbradyju@outlook.com> wrote:
An "interesting" effect of reindexing is that all the records that were dups in the nodes table were deleted, both copies.

Er...that's not just interesting, but alarming - if true. Can you show the steps you took?

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: exclusion constraint question
Next
From: Ron Johnson
Date:
Subject: Re: Duplicate Key Values