Re: Need help with corrupt pg_statistic

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Need help with corrupt pg_statistic
Дата
Msg-id 10288.1128304882@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Need help with corrupt pg_statistic  (Kevin Seghetti <kts@tenetti.org>)
Список pgsql-admin
Kevin Seghetti <kts@tenetti.org> writes:
> Is there any way to nuke pg_statistic (since its contents can be
> recalculated anyway?)

You want to do "TRUNCATE pg_statistic"; to avoid the permission check,
you'll need to do that in a standalone backend with -O option.

Do *not* try to drop and recreate it --- its OID is hardwired into
various places.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum Full Analyze Stalled
Следующее
От: David Fetter
Дата:
Сообщение: Re: [HACKERS] pgAdmin guru hints