could not create unique index, table contains duplicated values

Поиск
Список
Период
Сортировка
Искать
От
Christian Hofmann
Тема
could not create unique index, table contains duplicated values
Дата
Msg-id
000a01c5f39b$e1bf2c90$7b00a8c0@taschenrechner
Список
Дерево обсуждения
could not create unique index, table contains duplicated values "Christian Hofmann" <christian.hofmann@gmx.de>
Re: could not create unique index, table contains Oliver Elphick <olly@lfix.co.uk>
Hello,

I have a table with two columns (id, names).

At this time there is no index, because i have not needed any one.

There are about 120 million rows. Now I want to delete all duplicate rows.
I thought I could just create a unique index and postgresql qould do the
rest. But ok. Maybe postgresql didn't know which rows to delete.

Is there a query that will delete all rows where the same name is more than
one time in the table?
I only want to have every name once in the table.

My method to write a programm, select every row and cvompare it to the
others would be very slow.

There is something with a having statement, but I don't get the clue to
build that statement.

Can you help me?

Thank you very much,

Christian


В списке pgsql-novice по дате отправления
От: Andreas Kretschmer
Дата:
Сообщение: Re: MSSQL migration questions
От: Oliver Elphick
Дата:
FAQ