Re: Duplicate Key Values - Mailing list pgsql-general

From mark bradley
Subject Re: Duplicate Key Values
Date
Msg-id SJ2PR22MB4328267BD9F601D90601715BBAD12@SJ2PR22MB4328.namprd22.prod.outlook.com
Whole thread Raw
In response to Re: Duplicate Key Values  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Duplicate Key Values
List pgsql-general
The rows that were preserved in the nodes table were the ones that were not dups originally.  


Best regards,
Mark Brady

From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Tuesday, March 11, 2025 10:56 AM
To: mark bradley <markbradyju@outlook.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Duplicate Key Values
 
On 3/11/25 07:28, mark bradley wrote:
> An "interesting" effect of reindexing is that all the records that were
> dups in the nodes table were deleted, both copies.

I am trying to understand above.

Was there at least one row of each node_id left?

>
> Also, all rows having node_id as a foreign key in other tables were
> deleted, which means all rows in these tables were deleted.
>
> Fortunately these are not huge tables.  I will reenter the data, make a
> backup, and then try your further extended suggestions.
>
> Best regards,
> Mark Brady
> _amazon.com/author/markjbrady <https://amazon.com/author/markjbrady>_


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values
Next
From: Adrian Klaver
Date:
Subject: Re: Duplicate Key Values