Re: Duplicate Key Values
От
Adrian Klaver
Тема
Re: Duplicate Key Values
Дата
Msg-id
d9c4c12e-fcf9-44a6-becc-f7c852f62ed4@aklaver.com
Ответ на
Re: Duplicate Key Values (mark bradley)
Список
Дерево обсуждения
Duplicate Key Values mark bradley <markbradyju@outlook.com>
Re: Duplicate Key Values Ron Johnson <ronljohnsonjr@gmail.com>
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 _ -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления
