Re: duplicate primary index in bayes db from SpamAssassin

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: duplicate primary index in bayes db from SpamAssassin
Дата
Msg-id 6626.1210170774@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: duplicate primary index in bayes db from SpamAssassin  (Michael Monnerie <michael.monnerie@it-management.at>)
Ответы Re: duplicate primary index in bayes db from SpamAssassin
Список pgsql-admin
Michael Monnerie <michael.monnerie@it-management.at> writes:
> So probably this is this kind of "should never ever happen" except your
> machine goes bye-bye badly. What makes me a bit worried is that pg_dump
> did not report an error at all, but made it's backup as if everything
> is OK. Could that be changed maybe so that in case of a problem it at
> least cries out loudly "broken db found" or so?

pg_dump intentionally does *not* look at the contents of indexes (at
least not any on user tables).  I think this is a good thing because
it makes it more likely that you can dump a damaged database.  pg_dump
is not supposed to be some kind of fsck-like tool.

            regards, tom lane

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

Предыдущее
От: "Richard Broersma"
Дата:
Сообщение: Re: column: on update update?
Следующее
От: Michael Monnerie
Дата:
Сообщение: Re: duplicate primary index in bayes db from SpamAssassin