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