Re: Duplicate Key Values - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Duplicate Key Values
Date
Msg-id d9c4c12e-fcf9-44a6-becc-f7c852f62ed4@aklaver.com
Whole thread Raw
In response to Re: Duplicate Key Values  (mark bradley <markbradyju@outlook.com>)
Responses Re: Duplicate Key Values
List pgsql-general
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: Ron Johnson
Date:
Subject: Re: Duplicate Key Values
Next
From: mark bradley
Date:
Subject: Re: Duplicate Key Values