Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?
Дата
Msg-id 629440.1605458083@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?  (Morris de Oryx <morrisdeoryx@gmail.com>)
Ответы Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?  (Morris de Oryx <morrisdeoryx@gmail.com>)
Список pgsql-general
Morris de Oryx <morrisdeoryx@gmail.com> writes:
> After posting, I realized that this is likely a Stupid User Error. I was
> mucking around, and did something along the lines of
> delete from pg_statistic_ext;
> or
> delete from pg_stats_ext;

> ...instead of DROP STATISTICS calls. Would this likely explain what I'm
> seeing?

Ah, yeah, it likely would.

If this isn't a throwaway database, what you'd have to do to clear the
errors is to find and remove the now-dangling links to the deleted objects
in pg_depend.

            regards, tom lane



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Restoring database from false update
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: New "function tables" in V13 documentation