Search Postgresql Archives

Re: Duplicate Key Values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux