vacuum analyze - cannot insert duplicate key...

Поиск
Список
Период
Сортировка
От Patrick Coulombe
Тема vacuum analyze - cannot insert duplicate key...
Дата
Msg-id 002901c14a7d$6dc9e580$357cca18@caroline
обсуждение исходный текст
Ответы Re: vacuum analyze - cannot insert duplicate key...
Список pgsql-novice
medias=> vacuum analyze;
ERROR:  Cannot insert a duplicate key into a unique index


why i get this message, it's not the first time that i vacuum analyze my db.
but today, for a reason that i don't know, i got this message.

can you help me to find the error and fix it.
[PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

i know, my version of postgresql is old. if you have a url who explain step
by step how to upgrade to 7.1, i will probably find the time to do it.

patrick


В списке pgsql-novice по дате отправления:

Предыдущее
От: "WIERS,FREDERIK (HP-Netherlands,ex1)"
Дата:
Сообщение: Finding table-info per database, not tableowner
Следующее
От: Einar Karttunen
Дата:
Сообщение: Re: vacuum analyze - cannot insert duplicate key...